Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 9999 |
| Missing cells | 92654 |
| Missing cells (%) | 32.0% |
| Duplicate rows | 3 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 2.2 MiB |
| Average record size in memory | 232.0 B |
Variable types
| Categorical | 14 |
|---|---|
| Numeric | 15 |
event has constant value "Vehicle Connected" | Constant |
| Dataset has 3 (< 0.1%) duplicate rows | Duplicates |
vehicle_id has a high cardinality: 3421 distinct values | High cardinality |
user_id has a high cardinality: 3454 distinct values | High cardinality |
occurred_at_time has a high cardinality: 9718 distinct values | High cardinality |
app_version has a high cardinality: 107 distinct values | High cardinality |
battery_cells has a high cardinality: 782 distinct values | High cardinality |
battery_serial_number has a high cardinality: 4408 distinct values | High cardinality |
hmi_serial_number has a high cardinality: 3589 distinct values | High cardinality |
battery_error_state is highly overall correlated with versions_mc_firmware | High correlation |
battery_state_battery_soc is highly overall correlated with battery_state_pack_voltage and 1 other fields | High correlation |
battery_state_cell_temp_1 is highly overall correlated with battery_state_cell_temp_2 and 6 other fields | High correlation |
battery_state_cell_temp_2 is highly overall correlated with battery_state_cell_temp_1 and 6 other fields | High correlation |
battery_state_chg_temp is highly overall correlated with battery_state_cell_temp_1 and 6 other fields | High correlation |
battery_state_dsg_temp is highly overall correlated with battery_state_cell_temp_1 and 6 other fields | High correlation |
battery_state_full_capacity is highly overall correlated with battery_state_cell_temp_1 and 8 other fields | High correlation |
battery_state_pack_voltage is highly overall correlated with battery_state_battery_soc and 2 other fields | High correlation |
battery_state_pre_start_temp is highly overall correlated with battery_state_cell_temp_1 and 6 other fields | High correlation |
battery_state_remaining_capacity is highly overall correlated with battery_state_cell_temp_1 and 6 other fields | High correlation |
remaining_mileage is highly overall correlated with battery_state_battery_soc and 1 other fields | High correlation |
versions_mc_firmware is highly overall correlated with battery_error_state | High correlation |
os_name is highly overall correlated with battery_state_cell_temp_1 and 7 other fields | High correlation |
versions_battery_firmware is highly overall correlated with battery_state_full_capacity and 1 other fields | High correlation |
versions_hmi_firmware is highly overall correlated with battery_state_full_capacity and 2 other fields | High correlation |
versions_hmi_hardware is highly overall correlated with versions_hmi_firmware | High correlation |
versions_mc_firmware is highly imbalanced (96.5%) | Imbalance |
os_name is highly imbalanced (62.4%) | Imbalance |
versions_battery_firmware is highly imbalanced (50.1%) | Imbalance |
total_mileage has 1684 (16.8%) missing values | Missing |
versions_mc_firmware has 2026 (20.3%) missing values | Missing |
assist_level has 1798 (18.0%) missing values | Missing |
battery_cells has 8573 (85.7%) missing values | Missing |
battery_serial_number has 1925 (19.3%) missing values | Missing |
battery_state_battery_soc has 1907 (19.1%) missing values | Missing |
battery_state_battery_soh has 1907 (19.1%) missing values | Missing |
battery_state_cell_temp_1 has 8595 (86.0%) missing values | Missing |
battery_state_cell_temp_2 has 8595 (86.0%) missing values | Missing |
battery_state_chg_temp has 8595 (86.0%) missing values | Missing |
battery_state_dsg_temp has 8595 (86.0%) missing values | Missing |
battery_state_full_capacity has 8595 (86.0%) missing values | Missing |
battery_state_pack_voltage has 1907 (19.1%) missing values | Missing |
battery_state_pre_start_temp has 8595 (86.0%) missing values | Missing |
battery_state_real_time_current has 1907 (19.1%) missing values | Missing |
battery_state_remaining_capacity has 8595 (86.0%) missing values | Missing |
hmi_serial_number has 962 (9.6%) missing values | Missing |
remaining_mileage has 1739 (17.4%) missing values | Missing |
versions_battery_firmware has 2026 (20.3%) missing values | Missing |
versions_hmi_firmware has 2026 (20.3%) missing values | Missing |
versions_hmi_hardware has 2026 (20.3%) missing values | Missing |
total_mileage is highly skewed (γ1 = 24.03341074) | Skewed |
assist_level is highly skewed (γ1 = 23.94794415) | Skewed |
remaining_mileage is highly skewed (γ1 = 28.48081515) | Skewed |
occurred_at_time is uniformly distributed | Uniform |
assist_level has 475 (4.8%) zeros | Zeros |
battery_error_state has 9872 (98.7%) zeros | Zeros |
battery_state_cell_temp_1 has 591 (5.9%) zeros | Zeros |
battery_state_cell_temp_2 has 592 (5.9%) zeros | Zeros |
battery_state_chg_temp has 594 (5.9%) zeros | Zeros |
battery_state_dsg_temp has 594 (5.9%) zeros | Zeros |
battery_state_full_capacity has 591 (5.9%) zeros | Zeros |
battery_state_pre_start_temp has 594 (5.9%) zeros | Zeros |
battery_state_remaining_capacity has 591 (5.9%) zeros | Zeros |
Reproduction
| Analysis started | 2023-10-05 19:39:06.590692 |
|---|---|
| Analysis finished | 2023-10-05 19:40:25.158049 |
| Duration | 1 minute and 18.57 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
vehicle_id
Categorical
| Distinct | 3421 |
|---|---|
| Distinct (%) | 34.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| 5b3a3fb6-35ff-4d10-957a-68e50b9e9117 | 84 |
|---|---|
| fd878446-1c44-4a9f-b88f-10ce83cade59 | 47 |
| 382d4727-6119-4391-adc0-ac5500c489b6 | 47 |
| ca4c5d0d-0d08-4189-b8ee-e8cd4d337422 | 39 |
| a394bc6d-1c28-42d6-b473-88379f34d6aa | 36 |
| Other values (3416) |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Characters and Unicode
| Total characters | 359964 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1407 ? |
|---|---|
| Unique (%) | 14.1% |
Sample
| 1st row | bc3412f7-37a8-4676-8043-53f4a1bb316a |
|---|---|
| 2nd row | 95e7ee01-3987-481a-9000-3b331c52192f |
| 3rd row | c63d60f2-5e2a-483c-bb11-935c45ebf2f0 |
| 4th row | 79df825d-8115-4a84-9aa8-87ae307ae561 |
| 5th row | 0d30c889-a102-4bdc-b8a3-c1e0d6c536d5 |
Common Values
| Value | Count | Frequency (%) |
| 5b3a3fb6-35ff-4d10-957a-68e50b9e9117 | 84 | 0.8% |
| fd878446-1c44-4a9f-b88f-10ce83cade59 | 47 | 0.5% |
| 382d4727-6119-4391-adc0-ac5500c489b6 | 47 | 0.5% |
| ca4c5d0d-0d08-4189-b8ee-e8cd4d337422 | 39 | 0.4% |
| a394bc6d-1c28-42d6-b473-88379f34d6aa | 36 | 0.4% |
| 8a8278e1-021c-45fc-a485-66e41291b9e7 | 35 | 0.4% |
| 6eb63e1f-be68-42e6-9959-f962667b9d64 | 35 | 0.4% |
| 4cf2b02f-5631-4441-a93d-a1f2d59c83bf | 34 | 0.3% |
| 9d5c8861-faa8-4c13-960b-88d1cd147917 | 29 | 0.3% |
| df816c87-7f79-4834-9dc5-efc1391c886b | 29 | 0.3% |
| Other values (3411) | 9584 |
Length
| Value | Count | Frequency (%) |
| 5b3a3fb6-35ff-4d10-957a-68e50b9e9117 | 84 | 0.8% |
| fd878446-1c44-4a9f-b88f-10ce83cade59 | 47 | 0.5% |
| 382d4727-6119-4391-adc0-ac5500c489b6 | 47 | 0.5% |
| ca4c5d0d-0d08-4189-b8ee-e8cd4d337422 | 39 | 0.4% |
| a394bc6d-1c28-42d6-b473-88379f34d6aa | 36 | 0.4% |
| 8a8278e1-021c-45fc-a485-66e41291b9e7 | 35 | 0.4% |
| 6eb63e1f-be68-42e6-9959-f962667b9d64 | 35 | 0.4% |
| 4cf2b02f-5631-4441-a93d-a1f2d59c83bf | 34 | 0.3% |
| 24205f9c-7987-4984-9755-bd95f3305655 | 29 | 0.3% |
| df816c87-7f79-4834-9dc5-efc1391c886b | 29 | 0.3% |
| Other values (3411) | 9584 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 39996 | 11.1% |
| 4 | 28133 | 7.8% |
| 8 | 21712 | 6.0% |
| 9 | 21415 | 5.9% |
| b | 21375 | 5.9% |
| a | 21128 | 5.9% |
| 1 | 19365 | 5.4% |
| 5 | 19277 | 5.4% |
| 7 | 19103 | 5.3% |
| 3 | 18812 | 5.2% |
| Other values (7) | 129648 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 202618 | |
| Lowercase Letter | 117350 | |
| Dash Punctuation | 39996 | 11.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 28133 | |
| 8 | 21712 | |
| 9 | 21415 | |
| 1 | 19365 | |
| 5 | 19277 | |
| 7 | 19103 | |
| 3 | 18812 | |
| 6 | 18547 | |
| 0 | 18280 | |
| 2 | 17974 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 21375 | |
| a | 21128 | |
| c | 18801 | |
| d | 18792 | |
| f | 18709 | |
| e | 18545 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 39996 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 242614 | |
| Latin | 117350 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| - | 39996 | |
| 4 | 28133 | |
| 8 | 21712 | |
| 9 | 21415 | |
| 1 | 19365 | |
| 5 | 19277 | |
| 7 | 19103 | |
| 3 | 18812 | |
| 6 | 18547 | |
| 0 | 18280 |
Latin
| Value | Count | Frequency (%) |
| b | 21375 | |
| a | 21128 | |
| c | 18801 | |
| d | 18792 | |
| f | 18709 | |
| e | 18545 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 359964 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 39996 | 11.1% |
| 4 | 28133 | 7.8% |
| 8 | 21712 | 6.0% |
| 9 | 21415 | 5.9% |
| b | 21375 | 5.9% |
| a | 21128 | 5.9% |
| 1 | 19365 | 5.4% |
| 5 | 19277 | 5.4% |
| 7 | 19103 | 5.3% |
| 3 | 18812 | 5.2% |
| Other values (7) | 129648 |
user_id
Categorical
| Distinct | 3454 |
|---|---|
| Distinct (%) | 34.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| 2d213fa9-1951-4265-8725-5c0992b155c2 | 93 |
|---|---|
| d453aad8-6c95-425a-8a63-f9fe012554f8 | 47 |
| b16f77bf-6a58-49b0-8b8f-da7c7058bfbf | 47 |
| e9e81cc8-0fef-4a75-a851-7ca7ddfd117b | 41 |
| 98f8b924-0f17-4285-898e-9b95b6de6162 | 40 |
| Other values (3449) |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Characters and Unicode
| Total characters | 359964 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1504 ? |
|---|---|
| Unique (%) | 15.0% |
Sample
| 1st row | ca73adbe-5930-45ba-af74-de5865d8b093 |
|---|---|
| 2nd row | 6560e385-b90d-42be-b977-5cdb3a5d5a60 |
| 3rd row | 118047dc-bf44-4dc0-9862-0cb3ac5db65d |
| 4th row | f0c0ac6d-32a1-45ed-9de1-466455fa637a |
| 5th row | 2b9f8b3f-b3f3-409b-ade0-dd9ae8b54ba7 |
Common Values
| Value | Count | Frequency (%) |
| 2d213fa9-1951-4265-8725-5c0992b155c2 | 93 | 0.9% |
| d453aad8-6c95-425a-8a63-f9fe012554f8 | 47 | 0.5% |
| b16f77bf-6a58-49b0-8b8f-da7c7058bfbf | 47 | 0.5% |
| e9e81cc8-0fef-4a75-a851-7ca7ddfd117b | 41 | 0.4% |
| 98f8b924-0f17-4285-898e-9b95b6de6162 | 40 | 0.4% |
| 1b50bc7e-15c5-4ae7-822e-9b29988adf7b | 38 | 0.4% |
| 7d7c1e29-1a35-447c-b672-5899a55bc6f1 | 38 | 0.4% |
| 44ebfb1a-9cfe-4791-8fc3-f8e5a0ff9b74 | 38 | 0.4% |
| 2aef8afc-6d81-4c4b-b103-9bd4db52fe61 | 37 | 0.4% |
| 86ce07da-114d-48e7-8802-066b2ab4c087 | 36 | 0.4% |
| Other values (3444) | 9544 |
Length
| Value | Count | Frequency (%) |
| 2d213fa9-1951-4265-8725-5c0992b155c2 | 93 | 0.9% |
| b16f77bf-6a58-49b0-8b8f-da7c7058bfbf | 47 | 0.5% |
| d453aad8-6c95-425a-8a63-f9fe012554f8 | 47 | 0.5% |
| e9e81cc8-0fef-4a75-a851-7ca7ddfd117b | 41 | 0.4% |
| 98f8b924-0f17-4285-898e-9b95b6de6162 | 40 | 0.4% |
| 1b50bc7e-15c5-4ae7-822e-9b29988adf7b | 38 | 0.4% |
| 7d7c1e29-1a35-447c-b672-5899a55bc6f1 | 38 | 0.4% |
| 44ebfb1a-9cfe-4791-8fc3-f8e5a0ff9b74 | 38 | 0.4% |
| 2aef8afc-6d81-4c4b-b103-9bd4db52fe61 | 37 | 0.4% |
| 86ce07da-114d-48e7-8802-066b2ab4c087 | 36 | 0.4% |
| Other values (3444) | 9544 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 39996 | 11.1% |
| 4 | 28567 | 7.9% |
| 9 | 22159 | 6.2% |
| 8 | 21756 | 6.0% |
| b | 21147 | 5.9% |
| a | 20435 | 5.7% |
| 1 | 19689 | 5.5% |
| 6 | 19183 | 5.3% |
| 2 | 19098 | 5.3% |
| d | 19059 | 5.3% |
| Other values (7) | 128875 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 204147 | |
| Lowercase Letter | 115821 | |
| Dash Punctuation | 39996 | 11.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 28567 | |
| 9 | 22159 | |
| 8 | 21756 | |
| 1 | 19689 | |
| 6 | 19183 | |
| 2 | 19098 | |
| 5 | 19014 | |
| 7 | 18398 | |
| 3 | 18171 | |
| 0 | 18112 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 21147 | |
| a | 20435 | |
| d | 19059 | |
| f | 18489 | |
| e | 18355 | |
| c | 18336 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 39996 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 244143 | |
| Latin | 115821 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| - | 39996 | |
| 4 | 28567 | |
| 9 | 22159 | |
| 8 | 21756 | |
| 1 | 19689 | |
| 6 | 19183 | |
| 2 | 19098 | |
| 5 | 19014 | |
| 7 | 18398 | |
| 3 | 18171 |
Latin
| Value | Count | Frequency (%) |
| b | 21147 | |
| a | 20435 | |
| d | 19059 | |
| f | 18489 | |
| e | 18355 | |
| c | 18336 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 359964 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 39996 | 11.1% |
| 4 | 28567 | 7.9% |
| 9 | 22159 | 6.2% |
| 8 | 21756 | 6.0% |
| b | 21147 | 5.9% |
| a | 20435 | 5.7% |
| 1 | 19689 | 5.5% |
| 6 | 19183 | 5.3% |
| 2 | 19098 | 5.3% |
| d | 19059 | 5.3% |
| Other values (7) | 128875 |
total_mileage
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 6330 |
|---|---|
| Distinct (%) | 76.1% |
| Missing | 1684 |
| Missing (%) | 16.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6647965.3 |
| Minimum | 0 |
|---|---|
| Maximum | 4.2357077 × 109 |
| Zeros | 83 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 248 |
| Q1 | 2188.5 |
| median | 5647 |
| Q3 | 10993 |
| 95-th percentile | 18622.2 |
| Maximum | 4.2357077 × 109 |
| Range | 4.2357077 × 109 |
| Interquartile range (IQR) | 8804.5 |
Descriptive statistics
| Standard deviation | 1.4550904 × 108 |
|---|---|
| Coefficient of variation (CV) | 21.887755 |
| Kurtosis | 602.62127 |
| Mean | 6647965.3 |
| Median Absolute Deviation (MAD) | 3995 |
| Skewness | 24.033411 |
| Sum | 5.5277832 × 1010 |
| Variance | 2.117288 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 83 | 0.8% |
| 1 | 8 | 0.1% |
| 2 | 8 | 0.1% |
| 2112 | 8 | 0.1% |
| 663 | 7 | 0.1% |
| 63 | 7 | 0.1% |
| 6 | 6 | 0.1% |
| 937 | 6 | 0.1% |
| 11 | 6 | 0.1% |
| 2593 | 5 | 0.1% |
| Other values (6320) | 8171 | |
| (Missing) | 1684 | 16.8% |
| Value | Count | Frequency (%) |
| 0 | 83 | |
| 1 | 8 | 0.1% |
| 2 | 8 | 0.1% |
| 3 | 4 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 6 | 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 4 | < 0.1% |
| 11 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 4235707659 | 1 | |
| 4145238046 | 1 | |
| 4011373570 | 1 | |
| 3967496428 | 1 | |
| 3818981767 | 1 | |
| 3634652942 | 2 | |
| 3461804109 | 1 | |
| 3428659541 | 1 | |
| 3379368544 | 1 | |
| 3125455142 | 1 |
versions_mc_firmware
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2026 |
| Missing (%) | 20.3% |
| Memory size | 78.2 KiB |
| DA210815.10 | |
|---|---|
| 000000.0 | 54 |
| DA210727.9 | 16 |
| DA210524.7 | 5 |
| DA٢١٠٨١٥.10 | 3 |
| Other values (2) | 3 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.976922 |
| Min length | 8 |
Characters and Unicode
| Total characters | 87519 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 3 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DA210815.10 |
|---|---|
| 2nd row | DA210815.10 |
| 3rd row | DA210815.10 |
| 4th row | DA210815.10 |
| 5th row | DA210815.10 |
Common Values
| Value | Count | Frequency (%) |
| DA210815.10 | 7892 | |
| 000000.0 | 54 | 0.5% |
| DA210727.9 | 16 | 0.2% |
| DA210524.7 | 5 | 0.1% |
| DA٢١٠٨١٥.10 | 3 | < 0.1% |
| DA220125.11 | 2 | < 0.1% |
| DA081510.0 | 1 | < 0.1% |
| (Missing) | 2026 | 20.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| da210815.10 | 7892 | |
| 000000.0 | 54 | 0.7% |
| da210727.9 | 16 | 0.2% |
| da210524.7 | 5 | 0.1% |
| da٢١٠٨١٥.10 | 3 | < 0.1% |
| da220125.11 | 2 | < 0.1% |
| da081510.0 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 23708 | |
| 0 | 16191 | |
| . | 7973 | 9.1% |
| 2 | 7940 | 9.1% |
| D | 7919 | 9.0% |
| A | 7919 | 9.0% |
| 5 | 7900 | 9.0% |
| 8 | 7893 | 9.0% |
| 7 | 37 | < 0.1% |
| 9 | 16 | < 0.1% |
| Other values (6) | 23 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 63708 | |
| Uppercase Letter | 15838 | 18.1% |
| Other Punctuation | 7973 | 9.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 23708 | |
| 0 | 16191 | |
| 2 | 7940 | 12.5% |
| 5 | 7900 | 12.4% |
| 8 | 7893 | 12.4% |
| 7 | 37 | 0.1% |
| 9 | 16 | < 0.1% |
| Ù¡ | 6 | < 0.1% |
| 4 | 5 | < 0.1% |
| Ù¢ | 3 | < 0.1% |
| Other values (3) | 9 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 7919 | |
| A | 7919 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 7973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 71663 | |
| Latin | 15838 | 18.1% |
| Arabic | 18 | < 0.1% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 23708 | |
| 0 | 16191 | |
| . | 7973 | 11.1% |
| 2 | 7940 | 11.1% |
| 5 | 7900 | 11.0% |
| 8 | 7893 | 11.0% |
| 7 | 37 | 0.1% |
| 9 | 16 | < 0.1% |
| 4 | 5 | < 0.1% |
Arabic
| Value | Count | Frequency (%) |
| Ù¡ | 6 | |
| Ù¢ | 3 | |
| Ù | 3 | |
| Ù¨ | 3 | |
| Ù¥ | 3 |
Latin
| Value | Count | Frequency (%) |
| D | 7919 | |
| A | 7919 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87501 | |
| Arabic | 18 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 23708 | |
| 0 | 16191 | |
| . | 7973 | 9.1% |
| 2 | 7940 | 9.1% |
| D | 7919 | 9.1% |
| A | 7919 | 9.1% |
| 5 | 7900 | 9.0% |
| 8 | 7893 | 9.0% |
| 7 | 37 | < 0.1% |
| 9 | 16 | < 0.1% |
Arabic
| Value | Count | Frequency (%) |
| Ù¡ | 6 | |
| Ù¢ | 3 | |
| Ù | 3 | |
| Ù¨ | 3 | |
| Ù¥ | 3 |
occurred_at_time
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 9718 |
|---|---|
| Distinct (%) | 97.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| 2023-06-28 06:42:15 | 3 |
|---|---|
| 2023-07-12 18:47:18 | 3 |
| 2023-06-27 16:14:22 | 3 |
| 2022-08-17 09:21:58 | 3 |
| 2023-02-03 22:36:30 | 3 |
| Other values (9713) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 189981 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 9444 ? |
|---|---|
| Unique (%) | 94.4% |
Sample
| 1st row | 2023-04-05 08:54:50 |
|---|---|
| 2nd row | 2022-09-05 18:13:47 |
| 3rd row | 2023-09-10 12:22:06 |
| 4th row | 2022-09-14 07:50:05 |
| 5th row | 2022-09-12 14:12:19 |
Common Values
| Value | Count | Frequency (%) |
| 2023-06-28 06:42:15 | 3 | < 0.1% |
| 2023-07-12 18:47:18 | 3 | < 0.1% |
| 2023-06-27 16:14:22 | 3 | < 0.1% |
| 2022-08-17 09:21:58 | 3 | < 0.1% |
| 2023-02-03 22:36:30 | 3 | < 0.1% |
| 2023-06-20 12:31:43 | 3 | < 0.1% |
| 2022-09-28 13:53:29 | 3 | < 0.1% |
| 2023-03-28 16:35:30 | 2 | < 0.1% |
| 2022-08-16 14:03:25 | 2 | < 0.1% |
| 2023-08-28 09:06:32 | 2 | < 0.1% |
| Other values (9708) | 9972 |
Length
| Value | Count | Frequency (%) |
| 2023-09-06 | 94 | 0.5% |
| 2023-07-11 | 78 | 0.4% |
| 2023-09-13 | 74 | 0.4% |
| 2023-09-14 | 72 | 0.4% |
| 2023-09-07 | 69 | 0.3% |
| 2023-06-20 | 67 | 0.3% |
| 2023-09-12 | 65 | 0.3% |
| 2023-09-18 | 65 | 0.3% |
| 2023-08-31 | 64 | 0.3% |
| 2023-09-11 | 63 | 0.3% |
| Other values (9413) | 19287 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 34758 | |
| 0 | 31781 | |
| 1 | 20322 | |
| - | 19998 | |
| : | 19998 | |
| 3 | 14799 | |
| 9999 | 5.3% | |
| 5 | 7983 | 4.2% |
| 4 | 7420 | 3.9% |
| 7 | 5872 | 3.1% |
| Other values (3) | 17051 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 139986 | |
| Dash Punctuation | 19998 | 10.5% |
| Other Punctuation | 19998 | 10.5% |
| Space Separator | 9999 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 34758 | |
| 0 | 31781 | |
| 1 | 20322 | |
| 3 | 14799 | |
| 5 | 7983 | 5.7% |
| 4 | 7420 | 5.3% |
| 7 | 5872 | 4.2% |
| 8 | 5810 | 4.2% |
| 6 | 5702 | 4.1% |
| 9 | 5539 | 4.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19998 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 19998 |
Space Separator
| Value | Count | Frequency (%) |
| 9999 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 189981 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 34758 | |
| 0 | 31781 | |
| 1 | 20322 | |
| - | 19998 | |
| : | 19998 | |
| 3 | 14799 | |
| 9999 | 5.3% | |
| 5 | 7983 | 4.2% |
| 4 | 7420 | 3.9% |
| 7 | 5872 | 3.1% |
| Other values (3) | 17051 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 189981 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 34758 | |
| 0 | 31781 | |
| 1 | 20322 | |
| - | 19998 | |
| : | 19998 | |
| 3 | 14799 | |
| 9999 | 5.3% | |
| 5 | 7983 | 4.2% |
| 4 | 7420 | 3.9% |
| 7 | 5872 | 3.1% |
| Other values (3) | 17051 |
app_version
Categorical
| Distinct | 107 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| 2023.7.6 | 533 |
|---|---|
| 2023.8.16 | 471 |
| 2023.6.12 | 455 |
| 2023.4.21 | 451 |
| 2022.7.19 | 415 |
| Other values (102) |
Length
| Max length | 28 |
|---|---|
| Median length | 9 |
| Mean length | 11.638064 |
| Min length | 3 |
Characters and Unicode
| Total characters | 116369 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 2023.03.24-3923-prod-release |
|---|---|
| 2nd row | 2022.8.26 |
| 3rd row | 2023.9.4 |
| 4th row | 2022.08.30-3095-prod-release |
| 5th row | 2022.8.29 |
Common Values
| Value | Count | Frequency (%) |
| 2023.7.6 | 533 | 5.3% |
| 2023.8.16 | 471 | 4.7% |
| 2023.6.12 | 455 | 4.6% |
| 2023.4.21 | 451 | 4.5% |
| 2022.7.19 | 415 | 4.2% |
| 2022.8.26 | 307 | 3.1% |
| 2023.9.4 | 303 | 3.0% |
| 2023.3.28 | 285 | 2.9% |
| 2023.5.15 | 285 | 2.9% |
| 2023.1.11 | 284 | 2.8% |
| Other values (97) | 6210 |
Length
| Value | Count | Frequency (%) |
| 2023.7.6 | 533 | 5.3% |
| 2023.8.16 | 471 | 4.7% |
| 2023.6.12 | 455 | 4.6% |
| 2023.4.21 | 451 | 4.5% |
| 2022.7.19 | 415 | 4.2% |
| 2022.8.26 | 307 | 3.1% |
| 2023.9.4 | 303 | 3.0% |
| 2023.3.28 | 285 | 2.9% |
| 2023.5.15 | 285 | 2.9% |
| 2023.1.11 | 284 | 2.8% |
| Other values (97) | 6210 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 28319 | |
| . | 19990 | |
| 0 | 13343 | |
| 3 | 9230 | 7.9% |
| 1 | 8634 | 7.4% |
| - | 4313 | 3.7% |
| e | 4309 | 3.7% |
| 6 | 3467 | 3.0% |
| 8 | 3068 | 2.6% |
| 9 | 3050 | 2.6% |
| Other values (13) | 18646 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 76245 | |
| Other Punctuation | 19990 | 17.2% |
| Lowercase Letter | 15821 | 13.6% |
| Dash Punctuation | 4313 | 3.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4309 | |
| r | 2874 | |
| d | 1443 | 9.1% |
| o | 1439 | 9.1% |
| p | 1439 | 9.1% |
| l | 1435 | 9.1% |
| a | 1435 | 9.1% |
| s | 1435 | 9.1% |
| b | 4 | < 0.1% |
| u | 4 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 28319 | |
| 0 | 13343 | |
| 3 | 9230 | 12.1% |
| 1 | 8634 | 11.3% |
| 6 | 3467 | 4.5% |
| 8 | 3068 | 4.0% |
| 9 | 3050 | 4.0% |
| 7 | 2793 | 3.7% |
| 4 | 2669 | 3.5% |
| 5 | 1672 | 2.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 19990 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4313 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 100548 | |
| Latin | 15821 | 13.6% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 28319 | |
| . | 19990 | |
| 0 | 13343 | |
| 3 | 9230 | 9.2% |
| 1 | 8634 | 8.6% |
| - | 4313 | 4.3% |
| 6 | 3467 | 3.4% |
| 8 | 3068 | 3.1% |
| 9 | 3050 | 3.0% |
| 7 | 2793 | 2.8% |
| Other values (2) | 4341 | 4.3% |
Latin
| Value | Count | Frequency (%) |
| e | 4309 | |
| r | 2874 | |
| d | 1443 | 9.1% |
| o | 1439 | 9.1% |
| p | 1439 | 9.1% |
| l | 1435 | 9.1% |
| a | 1435 | 9.1% |
| s | 1435 | 9.1% |
| b | 4 | < 0.1% |
| u | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 116369 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 28319 | |
| . | 19990 | |
| 0 | 13343 | |
| 3 | 9230 | 7.9% |
| 1 | 8634 | 7.4% |
| - | 4313 | 3.7% |
| e | 4309 | 3.7% |
| 6 | 3467 | 3.0% |
| 8 | 3068 | 2.6% |
| 9 | 3050 | 2.6% |
| Other values (13) | 18646 |
assist_level
Real number (ℝ)
MISSING  SKEWED  ZEROS 
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1798 |
| Missing (%) | 18.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8598951 |
| Minimum | 0 |
|---|---|
| Maximum | 205 |
| Zeros | 475 |
| Zeros (%) | 4.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 205 |
| Range | 205 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 7.4874694 |
|---|---|
| Coefficient of variation (CV) | 4.0257481 |
| Kurtosis | 599.89668 |
| Mean | 1.8598951 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 23.947944 |
| Sum | 15253 |
| Variance | 56.062198 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 4835 | |
| 1 | 2874 | |
| 0 | 475 | 4.8% |
| 112 | 8 | 0.1% |
| 205 | 6 | 0.1% |
| 191 | 2 | < 0.1% |
| 201 | 1 | < 0.1% |
| (Missing) | 1798 | 18.0% |
| Value | Count | Frequency (%) |
| 0 | 475 | 4.8% |
| 1 | 2874 | |
| 2 | 4835 | |
| 112 | 8 | 0.1% |
| 191 | 2 | < 0.1% |
| 201 | 1 | < 0.1% |
| 205 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 205 | 6 | 0.1% |
| 201 | 1 | < 0.1% |
| 191 | 2 | < 0.1% |
| 112 | 8 | 0.1% |
| 2 | 4835 | |
| 1 | 2874 | |
| 0 | 475 | 4.8% |
battery_cells
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 782 |
|---|---|
| Distinct (%) | 54.8% |
| Missing | 8573 |
| Missing (%) | 85.7% |
| Memory size | 78.2 KiB |
| [null,null,null,null,null,null,null,null,null,null] | |
|---|---|
| [4021,4021,4023,4019,4022,4026,4024,3973,4007,4006] | 2 |
| [3933,3925,3942,3927,3933,3944,3936,3964,3961,3964] | 2 |
| [3864,3860,3870,3865,3881,3888,3886,3812,3823,3835] | 2 |
| [4107,4110,4106,4102,4106,4121,4121,4121,4121,4124] | 2 |
| Other values (777) |
Length
| Max length | 51 |
|---|---|
| Median length | 51 |
| Mean length | 50.957924 |
| Min length | 21 |
Characters and Unicode
| Total characters | 72666 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 756 ? |
|---|---|
| Unique (%) | 53.0% |
Sample
| 1st row | [null,null,null,null,null,null,null,null,null,null] |
|---|---|
| 2nd row | [3997,3997,4001,3994,4000,4013,4014,4015,4009,4012] |
| 3rd row | [4081,4081,4082,4083,4081,4085,4083,4083,4085,4083] |
| 4th row | [3913,3911,3911,3911,3911,3923,3921,3914,3923,3922] |
| 5th row | [null,null,null,null,null,null,null,null,null,null] |
Common Values
| Value | Count | Frequency (%) |
| [null,null,null,null,null,null,null,null,null,null] | 620 | 6.2% |
| [4021,4021,4023,4019,4022,4026,4024,3973,4007,4006] | 2 | < 0.1% |
| [3933,3925,3942,3927,3933,3944,3936,3964,3961,3964] | 2 | < 0.1% |
| [3864,3860,3870,3865,3881,3888,3886,3812,3823,3835] | 2 | < 0.1% |
| [4107,4110,4106,4102,4106,4121,4121,4121,4121,4124] | 2 | < 0.1% |
| [0,0,0,0,0,0,0,0,0,0] | 2 | < 0.1% |
| [3900,3902,3900,3902,3903,3918,3915,3744,3755,3756] | 2 | < 0.1% |
| [3814,3816,3811,3814,3815,3824,3823,3821,3820,3820] | 2 | < 0.1% |
| [4004,4005,4004,4000,4008,4016,4015,4017,4016,4017] | 2 | < 0.1% |
| [4015,4018,4013,4013,4012,4020,4022,4022,4022,4022] | 2 | < 0.1% |
| Other values (772) | 788 | 7.9% |
| (Missing) | 8573 |
Length
| Value | Count | Frequency (%) |
| null,null,null,null,null,null,null,null,null,null | 620 | |
| 4071,4068,4066,4069,4069,4072,4071,4070,4068,4071 | 2 | 0.1% |
| 3972,3954,3972,3957,3961,3971,3953,4004,3994,3994 | 2 | 0.1% |
| 3593,4073,4075,4072,4074,4076,4080,4079,4079,4080 | 2 | 0.1% |
| 3897,3886,3906,3893,3899,3909,3900,3948,3947,3956 | 2 | 0.1% |
| 3960,3956,3956,3959,3957,3973,3969,3966,3966,3967 | 2 | 0.1% |
| 4011,4014,4019,4019,4017,4019,4014,4023,4012,4011 | 2 | 0.1% |
| 3721,3711,3736,3714,3719,3733,3716,3724,3718,3727 | 2 | 0.1% |
| 3695,3692,3692,3694,3696,3706,3706,3476,3533,3538 | 2 | 0.1% |
| 4128,4120,4120,4129,4125,4147,4146,4142,4140,4145 | 2 | 0.1% |
| Other values (772) | 788 |
Most occurring characters
| Value | Count | Frequency (%) |
| , | 12834 | |
| l | 12508 | |
| 3 | 6700 | |
| n | 6254 | |
| u | 6254 | |
| 4 | 4892 | 6.7% |
| 0 | 3580 | 4.9% |
| 8 | 2904 | 4.0% |
| 9 | 2824 | 3.9% |
| 7 | 2470 | 3.4% |
| Other values (6) | 11446 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 31964 | |
| Lowercase Letter | 25016 | |
| Other Punctuation | 12834 | |
| Open Punctuation | 1426 | 2.0% |
| Close Punctuation | 1426 | 2.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 6700 | |
| 4 | 4892 | |
| 0 | 3580 | |
| 8 | 2904 | |
| 9 | 2824 | |
| 7 | 2470 | 7.7% |
| 1 | 2460 | 7.7% |
| 6 | 2357 | 7.4% |
| 5 | 2168 | 6.8% |
| 2 | 1609 | 5.0% |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 12508 | |
| n | 6254 | |
| u | 6254 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 12834 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 1426 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 1426 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 47650 | |
| Latin | 25016 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| , | 12834 | |
| 3 | 6700 | |
| 4 | 4892 | 10.3% |
| 0 | 3580 | 7.5% |
| 8 | 2904 | 6.1% |
| 9 | 2824 | 5.9% |
| 7 | 2470 | 5.2% |
| 1 | 2460 | 5.2% |
| 6 | 2357 | 4.9% |
| 5 | 2168 | 4.5% |
| Other values (3) | 4461 | 9.4% |
Latin
| Value | Count | Frequency (%) |
| l | 12508 | |
| n | 6254 | |
| u | 6254 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72666 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| , | 12834 | |
| l | 12508 | |
| 3 | 6700 | |
| n | 6254 | |
| u | 6254 | |
| 4 | 4892 | 6.7% |
| 0 | 3580 | 4.9% |
| 8 | 2904 | 4.0% |
| 9 | 2824 | 3.9% |
| 7 | 2470 | 3.4% |
| Other values (6) | 11446 |
battery_error_state
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 76 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9601744.3 |
| Minimum | 0 |
|---|---|
| Maximum | 2.1810381 × 109 |
| Zeros | 9872 |
| Zeros (%) | 98.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2.1810381 × 109 |
| Range | 2.1810381 × 109 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.4283984 × 108 |
|---|---|
| Coefficient of variation (CV) | 14.876447 |
| Kurtosis | 220.36174 |
| Mean | 9601744.3 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.906269 |
| Sum | 9.5278109 × 1010 |
| Variance | 2.040322 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9872 | |
| 2147615233 | 10 | 0.1% |
| 2147487776 | 10 | 0.1% |
| 2147483649 | 10 | 0.1% |
| 2147485728 | 5 | 0.1% |
| 205290152 | 3 | < 0.1% |
| 2164260864 | 2 | < 0.1% |
| 33556784 | 2 | < 0.1% |
| 2148663808 | 2 | < 0.1% |
| 16779536 | 2 | < 0.1% |
| Other values (5) | 5 | 0.1% |
| (Missing) | 76 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 9872 | |
| 16779536 | 2 | < 0.1% |
| 33556784 | 2 | < 0.1% |
| 205290152 | 3 | < 0.1% |
| 2147483649 | 10 | 0.1% |
| 2147485728 | 5 | 0.1% |
| 2147487776 | 10 | 0.1% |
| 2147489824 | 1 | < 0.1% |
| 2147614720 | 1 | < 0.1% |
| 2147614722 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2181038080 | 1 | < 0.1% |
| 2164260864 | 2 | < 0.1% |
| 2148663810 | 1 | < 0.1% |
| 2148663808 | 2 | < 0.1% |
| 2147615233 | 10 | |
| 2147614722 | 1 | < 0.1% |
| 2147614720 | 1 | < 0.1% |
| 2147489824 | 1 | < 0.1% |
| 2147487776 | 10 | |
| 2147485728 | 5 |
battery_serial_number
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 4408 |
|---|---|
| Distinct (%) | 54.6% |
| Missing | 1925 |
| Missing (%) | 19.3% |
| Memory size | 78.2 KiB |
| 2VHT02401P02-P4BR522 | 140 |
|---|---|
| BAT_SN | 125 |
| HT1002MA121520110 | 33 |
| HT1002MA121520478 | 30 |
| 3256485430323430315030322d50344252353232 | 27 |
| Other values (4403) |
Length
| Max length | 512 |
|---|---|
| Median length | 17 |
| Mean length | 56.547684 |
| Min length | 6 |
Characters and Unicode
| Total characters | 456566 |
|---|---|
| Distinct characters | 45 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 3000 ? |
|---|---|
| Unique (%) | 37.2% |
Sample
| 1st row | HT1002MA121521183 |
|---|---|
| 2nd row | HT1002MA121251821 |
| 3rd row | 4854313030324d41313231353231373236000000 |
| 4th row | HT1002MA122120371HT1002MA122120371HT1002MA122120371HT1002MA122120371HT1002MA122120371 |
| 5th row | HT1002MA121340143 |
Common Values
| Value | Count | Frequency (%) |
| 2VHT02401P02-P4BR522 | 140 | 1.4% |
| BAT_SN | 125 | 1.3% |
| HT1002MA121520110 | 33 | 0.3% |
| HT1002MA121520478 | 30 | 0.3% |
| 3256485430323430315030322d50344252353232 | 27 | 0.3% |
| HT1002MA122080723 | 26 | 0.3% |
| HT1002MA121520980 | 24 | 0.2% |
| HT1002MA122080276 | 20 | 0.2% |
| HT1002MA121521549 | 20 | 0.2% |
| HT1002MA121402126 | 18 | 0.2% |
| Other values (4398) | 7611 | |
| (Missing) | 1925 | 19.3% |
Length
| Value | Count | Frequency (%) |
| ht1002ma123240225 | 166 | 1.8% |
| 123 | 156 | 1.7% |
| 2vht02401p02-p4br522 | 140 | 1.5% |
| bat_sn | 125 | 1.3% |
| 12398122long | 74 | 0.8% |
| 123ht1002ma32233064long | 59 | 0.6% |
| ht1002ma323310199 | 50 | 0.5% |
| 123ht1002ma32233096long | 40 | 0.4% |
| ht1002ma322391121 | 39 | 0.4% |
| ht1002ma121520110 | 33 | 0.4% |
| Other values (4381) | 8378 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 89442 | |
| 0 | 87109 | |
| 1 | 74164 | |
| 3 | 26261 | 5.8% |
| T | 24962 | 5.5% |
| H | 24803 | 5.4% |
| A | 24758 | 5.4% |
| M | 24560 | 5.4% |
| 4 | 21645 | 4.7% |
| 5 | 14242 | 3.1% |
| Other values (35) | 44620 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 350215 | |
| Uppercase Letter | 103239 | 22.6% |
| Control | 1265 | 0.3% |
| Lowercase Letter | 801 | 0.2% |
| Space Separator | 641 | 0.1% |
| Dash Punctuation | 239 | 0.1% |
| Connector Punctuation | 161 | < 0.1% |
| Other Punctuation | 5 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 24962 | |
| H | 24803 | |
| A | 24758 | |
| M | 24560 | |
| N | 795 | 0.8% |
| G | 640 | 0.6% |
| L | 636 | 0.6% |
| O | 636 | 0.6% |
| P | 478 | 0.5% |
| B | 408 | 0.4% |
| Other values (7) | 563 | 0.5% |
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 707 | |
| e | 23 | 2.9% |
| i | 12 | 1.5% |
| t | 12 | 1.5% |
| c | 6 | 0.7% |
| v | 6 | 0.7% |
| n | 6 | 0.7% |
| g | 6 | 0.7% |
| a | 6 | 0.7% |
| r | 6 | 0.7% |
| Other values (2) | 11 | 1.4% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 89442 | |
| 0 | 87109 | |
| 1 | 74164 | |
| 3 | 26261 | 7.5% |
| 4 | 21645 | 6.2% |
| 5 | 14242 | 4.1% |
| 6 | 11662 | 3.3% |
| 8 | 11269 | 3.2% |
| 9 | 7272 | 2.1% |
| 7 | 7149 | 2.0% |
Control
| Value | Count | Frequency (%) |
| 633 | ||
| 632 |
Space Separator
| Value | Count | Frequency (%) |
| 641 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 239 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 161 |
Other Punctuation
| Value | Count | Frequency (%) |
| ¡ | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 352526 | |
| Latin | 104040 | 22.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 24962 | |
| H | 24803 | |
| A | 24758 | |
| M | 24560 | |
| N | 795 | 0.8% |
| d | 707 | 0.7% |
| G | 640 | 0.6% |
| L | 636 | 0.6% |
| O | 636 | 0.6% |
| P | 478 | 0.5% |
| Other values (19) | 1065 | 1.0% |
Common
| Value | Count | Frequency (%) |
| 2 | 89442 | |
| 0 | 87109 | |
| 1 | 74164 | |
| 3 | 26261 | 7.4% |
| 4 | 21645 | 6.1% |
| 5 | 14242 | 4.0% |
| 6 | 11662 | 3.3% |
| 8 | 11269 | 3.2% |
| 9 | 7272 | 2.1% |
| 7 | 7149 | 2.0% |
| Other values (6) | 2311 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 456561 | |
| None | 5 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 89442 | |
| 0 | 87109 | |
| 1 | 74164 | |
| 3 | 26261 | 5.8% |
| T | 24962 | 5.5% |
| H | 24803 | 5.4% |
| A | 24758 | 5.4% |
| M | 24560 | 5.4% |
| 4 | 21645 | 4.7% |
| 5 | 14242 | 3.1% |
| Other values (34) | 44615 |
None
| Value | Count | Frequency (%) |
| ¡ | 5 |
battery_state_battery_soc
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 101 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 1907 |
| Missing (%) | 19.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 67.747158 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 13 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 26 |
| Q1 | 52 |
| median | 71 |
| Q3 | 86 |
| 95-th percentile | 99 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 34 |
Descriptive statistics
| Standard deviation | 22.789468 |
|---|---|
| Coefficient of variation (CV) | 0.33639003 |
| Kurtosis | -0.46337 |
| Mean | 67.747158 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | -0.55026616 |
| Sum | 548210 |
| Variance | 519.35987 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 295 | 3.0% |
| 99 | 199 | 2.0% |
| 86 | 164 | 1.6% |
| 98 | 159 | 1.6% |
| 82 | 159 | 1.6% |
| 87 | 154 | 1.5% |
| 88 | 151 | 1.5% |
| 85 | 150 | 1.5% |
| 81 | 149 | 1.5% |
| 80 | 144 | 1.4% |
| Other values (91) | 6368 | |
| (Missing) | 1907 | 19.1% |
| Value | Count | Frequency (%) |
| 0 | 13 | |
| 1 | 2 | < 0.1% |
| 2 | 3 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 7 | |
| 5 | 9 | |
| 6 | 6 | |
| 7 | 6 | |
| 8 | 9 | |
| 9 | 12 |
| Value | Count | Frequency (%) |
| 100 | 295 | |
| 99 | 199 | |
| 98 | 159 | |
| 97 | 129 | |
| 96 | 90 | 0.9% |
| 95 | 128 | |
| 94 | 103 | 1.0% |
| 93 | 127 | |
| 92 | 96 | 1.0% |
| 91 | 114 | 1.1% |
battery_state_battery_soh
Real number (ℝ)
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1907 |
| Missing (%) | 19.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 97.368018 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 14 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 93 |
| Q1 | 97 |
| median | 98 |
| Q3 | 99 |
| 95-th percentile | 99 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 4.6096689 |
|---|---|
| Coefficient of variation (CV) | 0.047342742 |
| Kurtosis | 342.50145 |
| Mean | 97.368018 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -16.583122 |
| Sum | 787902 |
| Variance | 21.249047 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99 | 3110 | |
| 98 | 1919 | |
| 97 | 1044 | 10.4% |
| 96 | 676 | 6.8% |
| 95 | 368 | 3.7% |
| 100 | 308 | 3.1% |
| 94 | 232 | 2.3% |
| 93 | 141 | 1.4% |
| 92 | 87 | 0.9% |
| 91 | 56 | 0.6% |
| Other values (15) | 151 | 1.5% |
| (Missing) | 1907 |
| Value | Count | Frequency (%) |
| 0 | 14 | |
| 72 | 2 | < 0.1% |
| 78 | 1 | < 0.1% |
| 79 | 2 | < 0.1% |
| 80 | 2 | < 0.1% |
| 81 | 1 | < 0.1% |
| 82 | 4 | < 0.1% |
| 83 | 1 | < 0.1% |
| 84 | 2 | < 0.1% |
| 85 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 308 | 3.1% |
| 99 | 3110 | |
| 98 | 1919 | |
| 97 | 1044 | 10.4% |
| 96 | 676 | 6.8% |
| 95 | 368 | 3.7% |
| 94 | 232 | 2.3% |
| 93 | 141 | 1.4% |
| 92 | 87 | 0.9% |
| 91 | 56 | 0.6% |
battery_state_cell_temp_1
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 39 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 8595 |
| Missing (%) | 86.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.729345 |
| Minimum | 0 |
|---|---|
| Maximum | 96 |
| Zeros | 591 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 26 |
| 95-th percentile | 33 |
| Maximum | 96 |
| Range | 96 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 13.416598 |
|---|---|
| Coefficient of variation (CV) | 0.9108754 |
| Kurtosis | -0.7973934 |
| Mean | 14.729345 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.11386607 |
| Sum | 20680 |
| Variance | 180.0051 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 591 | 5.9% |
| 26 | 72 | 0.7% |
| 27 | 65 | 0.7% |
| 25 | 61 | 0.6% |
| 29 | 58 | 0.6% |
| 23 | 56 | 0.6% |
| 21 | 56 | 0.6% |
| 24 | 49 | 0.5% |
| 28 | 49 | 0.5% |
| 22 | 45 | 0.5% |
| Other values (29) | 302 | 3.0% |
| (Missing) | 8595 |
| Value | Count | Frequency (%) |
| 0 | 591 | |
| 1 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 6 | 0.1% |
| 11 | 3 | < 0.1% |
| 12 | 5 | 0.1% |
| 13 | 7 | 0.1% |
| 14 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 96 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 39 | 2 | < 0.1% |
| 38 | 3 | < 0.1% |
| 37 | 2 | < 0.1% |
| 36 | 11 | |
| 35 | 14 | |
| 34 | 15 |
battery_state_cell_temp_2
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 38 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 8595 |
| Missing (%) | 86.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.598291 |
| Minimum | 0 |
|---|---|
| Maximum | 90 |
| Zeros | 592 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 26 |
| 95-th percentile | 32 |
| Maximum | 90 |
| Range | 90 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 13.287689 |
|---|---|
| Coefficient of variation (CV) | 0.91022225 |
| Kurtosis | -1.014763 |
| Mean | 14.598291 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.0852262 |
| Sum | 20496 |
| Variance | 176.56268 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 592 | 5.9% |
| 26 | 69 | 0.7% |
| 25 | 68 | 0.7% |
| 27 | 63 | 0.6% |
| 23 | 58 | 0.6% |
| 22 | 54 | 0.5% |
| 28 | 53 | 0.5% |
| 29 | 49 | 0.5% |
| 31 | 47 | 0.5% |
| 21 | 46 | 0.5% |
| Other values (28) | 305 | 3.1% |
| (Missing) | 8595 |
| Value | Count | Frequency (%) |
| 0 | 592 | |
| 1 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 5 | 0.1% |
| 11 | 3 | < 0.1% |
| 12 | 4 | < 0.1% |
| 13 | 8 | 0.1% |
| 14 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 90 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 41 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 39 | 2 | < 0.1% |
| 37 | 6 | 0.1% |
| 36 | 8 | 0.1% |
| 35 | 10 | 0.1% |
| 34 | 15 | |
| 33 | 25 |
battery_state_chg_temp
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 40 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 8595 |
| Missing (%) | 86.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.878205 |
| Minimum | 0 |
|---|---|
| Maximum | 255 |
| Zeros | 594 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 28 |
| 95-th percentile | 36 |
| Maximum | 255 |
| Range | 255 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 15.726824 |
|---|---|
| Coefficient of variation (CV) | 0.99046608 |
| Kurtosis | 36.205172 |
| Mean | 15.878205 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 2.5048222 |
| Sum | 22293 |
| Variance | 247.33298 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 594 | 5.9% |
| 25 | 67 | 0.7% |
| 28 | 54 | 0.5% |
| 31 | 49 | 0.5% |
| 27 | 45 | 0.5% |
| 29 | 44 | 0.4% |
| 22 | 44 | 0.4% |
| 30 | 42 | 0.4% |
| 26 | 41 | 0.4% |
| 33 | 38 | 0.4% |
| Other values (30) | 386 | 3.9% |
| (Missing) | 8595 |
| Value | Count | Frequency (%) |
| 0 | 594 | |
| 6 | 1 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 3 | < 0.1% |
| 11 | 7 | 0.1% |
| 12 | 4 | < 0.1% |
| 13 | 2 | < 0.1% |
| 14 | 10 | 0.1% |
| 15 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 255 | 1 | < 0.1% |
| 48 | 1 | < 0.1% |
| 47 | 1 | < 0.1% |
| 43 | 3 | < 0.1% |
| 41 | 6 | 0.1% |
| 40 | 11 | |
| 39 | 9 | |
| 38 | 15 | |
| 37 | 19 | |
| 36 | 21 |
battery_state_dsg_temp
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 40 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 8595 |
| Missing (%) | 86.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.881766 |
| Minimum | 0 |
|---|---|
| Maximum | 255 |
| Zeros | 594 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 28 |
| 95-th percentile | 36 |
| Maximum | 255 |
| Range | 255 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 15.72855 |
|---|---|
| Coefficient of variation (CV) | 0.9903527 |
| Kurtosis | 36.185787 |
| Mean | 15.881766 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 2.5034773 |
| Sum | 22298 |
| Variance | 247.38729 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 594 | 5.9% |
| 25 | 67 | 0.7% |
| 28 | 54 | 0.5% |
| 31 | 49 | 0.5% |
| 27 | 45 | 0.5% |
| 29 | 44 | 0.4% |
| 22 | 44 | 0.4% |
| 24 | 42 | 0.4% |
| 30 | 42 | 0.4% |
| 26 | 41 | 0.4% |
| Other values (30) | 382 | 3.8% |
| (Missing) | 8595 |
| Value | Count | Frequency (%) |
| 0 | 594 | |
| 6 | 1 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 3 | < 0.1% |
| 11 | 7 | 0.1% |
| 12 | 4 | < 0.1% |
| 13 | 2 | < 0.1% |
| 14 | 10 | 0.1% |
| 15 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 255 | 1 | < 0.1% |
| 48 | 1 | < 0.1% |
| 47 | 1 | < 0.1% |
| 43 | 3 | < 0.1% |
| 41 | 6 | 0.1% |
| 40 | 11 | |
| 39 | 9 | |
| 38 | 15 | |
| 37 | 19 | |
| 36 | 21 |
battery_state_full_capacity
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 105 |
|---|---|
| Distinct (%) | 7.5% |
| Missing | 8595 |
| Missing (%) | 86.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5399.4993 |
| Minimum | 0 |
|---|---|
| Maximum | 9506 |
| Zeros | 591 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 9134 |
| Q3 | 9417 |
| 95-th percentile | 9491 |
| Maximum | 9506 |
| Range | 9506 |
| Interquartile range (IQR) | 9417 |
Descriptive statistics
| Standard deviation | 4608.0912 |
|---|---|
| Coefficient of variation (CV) | 0.85342936 |
| Kurtosis | -1.8976715 |
| Mean | 5399.4993 |
| Median Absolute Deviation (MAD) | 357 |
| Skewness | -0.31703031 |
| Sum | 7580897 |
| Variance | 21234505 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 591 | 5.9% |
| 9484 | 53 | 0.5% |
| 9499 | 41 | 0.4% |
| 9476 | 38 | 0.4% |
| 9468 | 31 | 0.3% |
| 9491 | 31 | 0.3% |
| 9506 | 27 | 0.3% |
| 9438 | 25 | 0.3% |
| 9461 | 24 | 0.2% |
| 9453 | 24 | 0.2% |
| Other values (95) | 519 | 5.2% |
| (Missing) | 8595 |
| Value | Count | Frequency (%) |
| 0 | 591 | |
| 8176 | 1 | < 0.1% |
| 8191 | 1 | < 0.1% |
| 8252 | 1 | < 0.1% |
| 8366 | 1 | < 0.1% |
| 8472 | 3 | < 0.1% |
| 8488 | 1 | < 0.1% |
| 8526 | 1 | < 0.1% |
| 8594 | 2 | < 0.1% |
| 8602 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 9506 | 27 | |
| 9499 | 41 | |
| 9491 | 31 | |
| 9484 | 53 | |
| 9476 | 38 | |
| 9468 | 31 | |
| 9461 | 24 | |
| 9453 | 24 | |
| 9446 | 22 | |
| 9438 | 25 |
battery_state_pack_voltage
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 5450 |
|---|---|
| Distinct (%) | 67.4% |
| Missing | 1907 |
| Missing (%) | 19.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -14984.501 |
| Minimum | -32766 |
|---|---|
| Maximum | 41878 |
| Zeros | 13 |
| Zeros (%) | 0.1% |
| Negative | 6581 |
| Negative (%) | 65.8% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | -32766 |
|---|---|
| 5-th percentile | -30447.45 |
| Q1 | -28052 |
| median | -26050.5 |
| Q3 | -24538 |
| 95-th percentile | 40512 |
| Maximum | 41878 |
| Range | 74644 |
| Interquartile range (IQR) | 3514 |
Descriptive statistics
| Standard deviation | 25319.913 |
|---|---|
| Coefficient of variation (CV) | -1.6897402 |
| Kurtosis | 0.70536722 |
| Mean | -14984.501 |
| Median Absolute Deviation (MAD) | 1792.5 |
| Skewness | 1.6250088 |
| Sum | -1.2125458 × 108 |
| Variance | 6.4109802 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4200 | 38 | 0.4% |
| 0 | 13 | 0.1% |
| -24821 | 7 | 0.1% |
| -24790 | 6 | 0.1% |
| -24777 | 6 | 0.1% |
| -24898 | 6 | 0.1% |
| -28275 | 6 | 0.1% |
| -27111 | 6 | 0.1% |
| -24804 | 6 | 0.1% |
| -24822 | 6 | 0.1% |
| Other values (5440) | 7992 | |
| (Missing) | 1907 | 19.1% |
| Value | Count | Frequency (%) |
| -32766 | 1 | |
| -32730 | 1 | |
| -32725 | 1 | |
| -32610 | 1 | |
| -32560 | 1 | |
| -32550 | 1 | |
| -32549 | 1 | |
| -32530 | 1 | |
| -32514 | 1 | |
| -32507 | 1 |
| Value | Count | Frequency (%) |
| 41878 | 1 | |
| 41865 | 1 | |
| 41849 | 1 | |
| 41824 | 1 | |
| 41818 | 1 | |
| 41816 | 1 | |
| 41815 | 1 | |
| 41814 | 1 | |
| 41812 | 1 | |
| 41798 | 1 |
battery_state_pre_start_temp
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 40 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 8595 |
| Missing (%) | 86.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.885328 |
| Minimum | 0 |
|---|---|
| Maximum | 255 |
| Zeros | 594 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 28 |
| 95-th percentile | 36 |
| Maximum | 255 |
| Range | 255 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 15.730502 |
|---|---|
| Coefficient of variation (CV) | 0.99025358 |
| Kurtosis | 36.164213 |
| Mean | 15.885328 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 2.5020697 |
| Sum | 22303 |
| Variance | 247.44871 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 594 | 5.9% |
| 25 | 72 | 0.7% |
| 28 | 54 | 0.5% |
| 31 | 49 | 0.5% |
| 27 | 45 | 0.5% |
| 29 | 44 | 0.4% |
| 22 | 44 | 0.4% |
| 30 | 42 | 0.4% |
| 26 | 41 | 0.4% |
| 33 | 38 | 0.4% |
| Other values (30) | 381 | 3.8% |
| (Missing) | 8595 |
| Value | Count | Frequency (%) |
| 0 | 594 | |
| 6 | 1 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 3 | < 0.1% |
| 11 | 7 | 0.1% |
| 12 | 4 | < 0.1% |
| 13 | 2 | < 0.1% |
| 14 | 10 | 0.1% |
| 15 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 255 | 1 | < 0.1% |
| 48 | 1 | < 0.1% |
| 47 | 1 | < 0.1% |
| 43 | 3 | < 0.1% |
| 41 | 6 | 0.1% |
| 40 | 11 | |
| 39 | 9 | |
| 38 | 15 | |
| 37 | 19 | |
| 36 | 21 |
battery_state_real_time_current
Real number (ℝ)
| Distinct | 1696 |
|---|---|
| Distinct (%) | 21.0% |
| Missing | 1907 |
| Missing (%) | 19.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1952.1338 |
| Minimum | -18610 |
|---|---|
| Maximum | 9252 |
| Zeros | 13 |
| Zeros (%) | 0.1% |
| Negative | 8072 |
| Negative (%) | 80.7% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | -18610 |
|---|---|
| 5-th percentile | -11700.85 |
| Q1 | -1469.75 |
| median | -74 |
| Q3 | -60 |
| 95-th percentile | -27 |
| Maximum | 9252 |
| Range | 27862 |
| Interquartile range (IQR) | 1409.75 |
Descriptive statistics
| Standard deviation | 3937.3694 |
|---|---|
| Coefficient of variation (CV) | -2.0169567 |
| Kurtosis | 3.7772679 |
| Mean | -1952.1338 |
| Median Absolute Deviation (MAD) | 19 |
| Skewness | -2.1826016 |
| Sum | -15796667 |
| Variance | 15502878 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -63 | 664 | 6.6% |
| -60 | 614 | 6.1% |
| -65 | 549 | 5.5% |
| -57 | 406 | 4.1% |
| -68 | 393 | 3.9% |
| -71 | 346 | 3.5% |
| -74 | 241 | 2.4% |
| -76 | 167 | 1.7% |
| -93 | 154 | 1.5% |
| -96 | 153 | 1.5% |
| Other values (1686) | 4405 | |
| (Missing) | 1907 |
| Value | Count | Frequency (%) |
| -18610 | 1 | |
| -17616 | 1 | |
| -17528 | 1 | |
| -16907 | 1 | |
| -16693 | 1 | |
| -16487 | 1 | |
| -16473 | 1 | |
| -16341 | 1 | |
| -16240 | 1 | |
| -16234 | 1 |
| Value | Count | Frequency (%) |
| 9252 | 1 | < 0.1% |
| 5654 | 1 | < 0.1% |
| 74 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 2 | 3 | < 0.1% |
| 0 | 13 | |
| -2 | 1 | < 0.1% |
| -5 | 1 | < 0.1% |
| -8 | 1 | < 0.1% |
| -9 | 1 | < 0.1% |
battery_state_remaining_capacity
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 734 |
|---|---|
| Distinct (%) | 52.3% |
| Missing | 8595 |
| Missing (%) | 86.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3817.8611 |
| Minimum | 0 |
|---|---|
| Maximum | 9498 |
| Zeros | 591 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3897 |
| Q3 | 7315.25 |
| 95-th percentile | 9128.7 |
| Maximum | 9498 |
| Range | 9498 |
| Interquartile range (IQR) | 7315.25 |
Descriptive statistics
| Standard deviation | 3624.0034 |
|---|---|
| Coefficient of variation (CV) | 0.94922347 |
| Kurtosis | -1.6721612 |
| Mean | 3817.8611 |
| Median Absolute Deviation (MAD) | 3897 |
| Skewness | 0.12921647 |
| Sum | 5360277 |
| Variance | 13133401 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 591 | 5.9% |
| 8250 | 5 | 0.1% |
| 6450 | 4 | < 0.1% |
| 8567 | 4 | < 0.1% |
| 9445 | 4 | < 0.1% |
| 7685 | 3 | < 0.1% |
| 7287 | 3 | < 0.1% |
| 9162 | 3 | < 0.1% |
| 9005 | 2 | < 0.1% |
| 4731 | 2 | < 0.1% |
| Other values (724) | 783 | 7.8% |
| (Missing) | 8595 |
| Value | Count | Frequency (%) |
| 0 | 591 | |
| 164 | 1 | < 0.1% |
| 404 | 1 | < 0.1% |
| 507 | 1 | < 0.1% |
| 646 | 1 | < 0.1% |
| 943 | 1 | < 0.1% |
| 976 | 1 | < 0.1% |
| 991 | 1 | < 0.1% |
| 1066 | 1 | < 0.1% |
| 1150 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9498 | 1 | < 0.1% |
| 9488 | 1 | < 0.1% |
| 9483 | 2 | |
| 9467 | 1 | < 0.1% |
| 9445 | 4 | |
| 9441 | 1 | < 0.1% |
| 9437 | 2 | |
| 9434 | 1 | < 0.1% |
| 9429 | 1 | < 0.1% |
| 9425 | 1 | < 0.1% |
dance_area
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| PARIS | |
|---|---|
| BERLIN | |
| HAMBURG | |
| MUNICH | 392 |
| VIENNA | 331 |
Length
| Max length | 11 |
|---|---|
| Median length | 5 |
| Mean length | 5.6324632 |
| Min length | 5 |
Characters and Unicode
| Total characters | 56319 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PARIS |
|---|---|
| 2nd row | PARIS |
| 3rd row | BERLIN |
| 4th row | BERLIN |
| 5th row | HAMBURG |
Common Values
| Value | Count | Frequency (%) |
| PARIS | 5073 | |
| BERLIN | 2821 | |
| HAMBURG | 1378 | 13.8% |
| MUNICH | 392 | 3.9% |
| VIENNA | 331 | 3.3% |
| UNALLOCATED | 4 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| paris | 5073 | |
| berlin | 2821 | |
| hamburg | 1378 | 13.8% |
| munich | 392 | 3.9% |
| vienna | 331 | 3.3% |
| unallocated | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 9272 | |
| I | 8617 | |
| A | 6790 | |
| P | 5073 | |
| S | 5073 | |
| B | 4199 | |
| N | 3879 | |
| E | 3156 | 5.6% |
| L | 2829 | 5.0% |
| U | 1774 | 3.1% |
| Other values (8) | 5657 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 56319 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 9272 | |
| I | 8617 | |
| A | 6790 | |
| P | 5073 | |
| S | 5073 | |
| B | 4199 | |
| N | 3879 | |
| E | 3156 | 5.6% |
| L | 2829 | 5.0% |
| U | 1774 | 3.1% |
| Other values (8) | 5657 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 56319 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 9272 | |
| I | 8617 | |
| A | 6790 | |
| P | 5073 | |
| S | 5073 | |
| B | 4199 | |
| N | 3879 | |
| E | 3156 | 5.6% |
| L | 2829 | 5.0% |
| U | 1774 | 3.1% |
| Other values (8) | 5657 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 56319 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 9272 | |
| I | 8617 | |
| A | 6790 | |
| P | 5073 | |
| S | 5073 | |
| B | 4199 | |
| N | 3879 | |
| E | 3156 | 5.6% |
| L | 2829 | 5.0% |
| U | 1774 | 3.1% |
| Other values (8) | 5657 |
event
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| Vehicle Connected |
|---|
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 17 |
| Min length | 17 |
Characters and Unicode
| Total characters | 169983 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Vehicle Connected |
|---|---|
| 2nd row | Vehicle Connected |
| 3rd row | Vehicle Connected |
| 4th row | Vehicle Connected |
| 5th row | Vehicle Connected |
Common Values
| Value | Count | Frequency (%) |
| Vehicle Connected | 9999 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| vehicle | 9999 | |
| connected | 9999 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 39996 | |
| c | 19998 | |
| n | 19998 | |
| V | 9999 | 5.9% |
| h | 9999 | 5.9% |
| i | 9999 | 5.9% |
| l | 9999 | 5.9% |
| 9999 | 5.9% | |
| C | 9999 | 5.9% |
| o | 9999 | 5.9% |
| Other values (2) | 19998 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 139986 | |
| Uppercase Letter | 19998 | 11.8% |
| Space Separator | 9999 | 5.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 39996 | |
| c | 19998 | |
| n | 19998 | |
| h | 9999 | 7.1% |
| i | 9999 | 7.1% |
| l | 9999 | 7.1% |
| o | 9999 | 7.1% |
| t | 9999 | 7.1% |
| d | 9999 | 7.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| V | 9999 | |
| C | 9999 |
Space Separator
| Value | Count | Frequency (%) |
| 9999 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 159984 | |
| Common | 9999 | 5.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 39996 | |
| c | 19998 | |
| n | 19998 | |
| V | 9999 | 6.2% |
| h | 9999 | 6.2% |
| i | 9999 | 6.2% |
| l | 9999 | 6.2% |
| C | 9999 | 6.2% |
| o | 9999 | 6.2% |
| t | 9999 | 6.2% |
Common
| Value | Count | Frequency (%) |
| 9999 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 169983 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 39996 | |
| c | 19998 | |
| n | 19998 | |
| V | 9999 | 5.9% |
| h | 9999 | 5.9% |
| i | 9999 | 5.9% |
| l | 9999 | 5.9% |
| 9999 | 5.9% | |
| C | 9999 | 5.9% |
| o | 9999 | 5.9% |
| Other values (2) | 19998 |
hmi_serial_number
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 3589 |
|---|---|
| Distinct (%) | 39.7% |
| Missing | 962 |
| Missing (%) | 9.6% |
| Memory size | 78.2 KiB |
| E96F7C | 36 |
|---|---|
| F1F5B5 | 35 |
| 1C25B6 | 35 |
| CA24C6 | 31 |
| EF1522 | 30 |
| Other values (3584) |
Length
| Max length | 32 |
|---|---|
| Median length | 6 |
| Mean length | 6.9864999 |
| Min length | 6 |
Characters and Unicode
| Total characters | 63137 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1673 ? |
|---|---|
| Unique (%) | 18.5% |
Sample
| 1st row | 60968A |
|---|---|
| 2nd row | 2C139F |
| 3rd row | 73D58B |
| 4th row | 22491134 |
| 5th row | 89F0D3 |
Common Values
| Value | Count | Frequency (%) |
| E96F7C | 36 | 0.4% |
| F1F5B5 | 35 | 0.4% |
| 1C25B6 | 35 | 0.4% |
| CA24C6 | 31 | 0.3% |
| EF1522 | 30 | 0.3% |
| 8433D3 | 27 | 0.3% |
| BC86A0 | 26 | 0.3% |
| A3A8CB | 25 | 0.3% |
| 5B706B | 24 | 0.2% |
| 4AAFEB | 23 | 0.2% |
| Other values (3579) | 8745 | |
| (Missing) | 962 | 9.6% |
Length
| Value | Count | Frequency (%) |
| e96f7c | 36 | 0.4% |
| 1c25b6 | 35 | 0.4% |
| f1f5b5 | 35 | 0.4% |
| ca24c6 | 31 | 0.3% |
| ef1522 | 30 | 0.3% |
| 8433d3 | 27 | 0.3% |
| bc86a0 | 26 | 0.3% |
| a3a8cb | 25 | 0.3% |
| 5b706b | 24 | 0.3% |
| 4aafeb | 23 | 0.3% |
| Other values (3579) | 8745 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 8218 | |
| 3 | 6628 | |
| 4 | 5974 | |
| 1 | 5295 | 8.4% |
| 0 | 5037 | 8.0% |
| 5 | 4379 | 6.9% |
| 9 | 4139 | 6.6% |
| 6 | 3450 | 5.5% |
| 7 | 3206 | 5.1% |
| 8 | 2924 | 4.6% |
| Other values (8) | 13887 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 49250 | |
| Uppercase Letter | 13883 | 22.0% |
| Lowercase Letter | 4 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 8218 | |
| 3 | 6628 | |
| 4 | 5974 | |
| 1 | 5295 | |
| 0 | 5037 | |
| 5 | 4379 | |
| 9 | 4139 | |
| 6 | 3450 | |
| 7 | 3206 | 6.5% |
| 8 | 2924 | 5.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 2531 | |
| C | 2310 | |
| F | 2283 | |
| E | 2272 | |
| D | 2239 | |
| A | 2239 | |
| N | 9 | 0.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 49250 | |
| Latin | 13887 | 22.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 8218 | |
| 3 | 6628 | |
| 4 | 5974 | |
| 1 | 5295 | |
| 0 | 5037 | |
| 5 | 4379 | |
| 9 | 4139 | |
| 6 | 3450 | |
| 7 | 3206 | 6.5% |
| 8 | 2924 | 5.9% |
Latin
| Value | Count | Frequency (%) |
| B | 2531 | |
| C | 2310 | |
| F | 2283 | |
| E | 2272 | |
| D | 2239 | |
| A | 2239 | |
| N | 9 | 0.1% |
| e | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 63137 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 8218 | |
| 3 | 6628 | |
| 4 | 5974 | |
| 1 | 5295 | 8.4% |
| 0 | 5037 | 8.0% |
| 5 | 4379 | 6.9% |
| 9 | 4139 | 6.6% |
| 6 | 3450 | 5.5% |
| 7 | 3206 | 5.1% |
| 8 | 2924 | 4.6% |
| Other values (8) | 13887 |
os_name
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| iOS | |
|---|---|
| Android | |
| iPadOS | 1 |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 3.5759576 |
| Min length | 3 |
Characters and Unicode
| Total characters | 35756 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Android |
|---|---|
| 2nd row | iOS |
| 3rd row | iOS |
| 4th row | Android |
| 5th row | iOS |
Common Values
| Value | Count | Frequency (%) |
| iOS | 8559 | |
| Android | 1439 | 14.4% |
| iPadOS | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ios | 8559 | |
| android | 1439 | 14.4% |
| ipados | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 9999 | |
| O | 8560 | |
| S | 8560 | |
| d | 2879 | 8.1% |
| A | 1439 | 4.0% |
| n | 1439 | 4.0% |
| r | 1439 | 4.0% |
| o | 1439 | 4.0% |
| P | 1 | < 0.1% |
| a | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 18560 | |
| Lowercase Letter | 17196 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 9999 | |
| d | 2879 | 16.7% |
| n | 1439 | 8.4% |
| r | 1439 | 8.4% |
| o | 1439 | 8.4% |
| a | 1 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 8560 | |
| S | 8560 | |
| A | 1439 | 7.8% |
| P | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 35756 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 9999 | |
| O | 8560 | |
| S | 8560 | |
| d | 2879 | 8.1% |
| A | 1439 | 4.0% |
| n | 1439 | 4.0% |
| r | 1439 | 4.0% |
| o | 1439 | 4.0% |
| P | 1 | < 0.1% |
| a | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 35756 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 9999 | |
| O | 8560 | |
| S | 8560 | |
| d | 2879 | 8.1% |
| A | 1439 | 4.0% |
| n | 1439 | 4.0% |
| r | 1439 | 4.0% |
| o | 1439 | 4.0% |
| P | 1 | < 0.1% |
| a | 1 | < 0.1% |
remaining_mileage
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 258 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 1739 |
| Missing (%) | 17.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 561.40266 |
| Minimum | 0 |
|---|---|
| Maximum | 64131 |
| Zeros | 65 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 162 |
| Q1 | 342 |
| median | 472 |
| Q3 | 588 |
| 95-th percentile | 800 |
| Maximum | 64131 |
| Range | 64131 |
| Interquartile range (IQR) | 246 |
Descriptive statistics
| Standard deviation | 1668.7024 |
|---|---|
| Coefficient of variation (CV) | 2.9723806 |
| Kurtosis | 893.06205 |
| Mean | 561.40266 |
| Median Absolute Deviation (MAD) | 122 |
| Skewness | 28.480815 |
| Sum | 4637186 |
| Variance | 2784567.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 600 | 218 | 2.2% |
| 528 | 135 | 1.4% |
| 432 | 133 | 1.3% |
| 504 | 128 | 1.3% |
| 480 | 121 | 1.2% |
| 594 | 121 | 1.2% |
| 408 | 104 | 1.0% |
| 492 | 103 | 1.0% |
| 384 | 100 | 1.0% |
| 456 | 98 | 1.0% |
| Other values (248) | 6999 | |
| (Missing) | 1739 | 17.4% |
| Value | Count | Frequency (%) |
| 0 | 65 | |
| 8 | 2 | < 0.1% |
| 16 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 24 | 2 | < 0.1% |
| 32 | 1 | < 0.1% |
| 36 | 1 | < 0.1% |
| 40 | 7 | 0.1% |
| 48 | 6 | 0.1% |
| 54 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 64131 | 1 | |
| 62145 | 1 | |
| 52705 | 1 | |
| 50429 | 1 | |
| 44688 | 1 | |
| 43231 | 1 | |
| 42770 | 1 | |
| 35227 | 1 | |
| 27373 | 1 | |
| 27177 | 1 |
versions_battery_firmware
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2026 |
| Missing (%) | 20.3% |
| Memory size | 78.2 KiB |
| 1.0.6.0 | |
|---|---|
| 0.3.3.0 | |
| 1.0.3.0 | |
| 0.3.2.0 | |
| 1.0.2.0 | 205 |
| Other values (10) | 209 |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 7.0016305 |
| Min length | 7 |
Characters and Unicode
| Total characters | 55824 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0.3.3.0 |
|---|---|
| 2nd row | 0.3.3.0 |
| 3rd row | 1.0.6.0 |
| 4th row | 1.0.6.0 |
| 5th row | 1.0.6.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0.6.0 | 4031 | |
| 0.3.3.0 | 1963 | |
| 1.0.3.0 | 1074 | 10.7% |
| 0.3.2.0 | 491 | 4.9% |
| 1.0.2.0 | 205 | 2.1% |
| 0.0.0.0 | 141 | 1.4% |
| 0.3.1.0 | 31 | 0.3% |
| 1.0.1.0 | 17 | 0.2% |
| 0.2.2.0 | 8 | 0.1% |
| 0.2.6.0 | 5 | 0.1% |
| Other values (5) | 7 | 0.1% |
| (Missing) | 2026 |
Length
| Value | Count | Frequency (%) |
| 1.0.6.0 | 4031 | |
| 0.3.3.0 | 1963 | |
| 1.0.3.0 | 1074 | 13.5% |
| 0.3.2.0 | 491 | 6.2% |
| 1.0.2.0 | 205 | 2.6% |
| 0.0.0.0 | 141 | 1.8% |
| 0.3.1.0 | 31 | 0.4% |
| 1.0.1.0 | 17 | 0.2% |
| 0.2.2.0 | 8 | 0.1% |
| 0.2.6.0 | 5 | 0.1% |
| Other values (5) | 7 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 23919 | |
| 0 | 16226 | |
| 3 | 5522 | 9.9% |
| 1 | 5379 | 9.6% |
| 6 | 4036 | 7.2% |
| 2 | 720 | 1.3% |
| 5 | 11 | < 0.1% |
| 4 | 8 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 31905 | |
| Other Punctuation | 23919 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 16226 | |
| 3 | 5522 | 17.3% |
| 1 | 5379 | 16.9% |
| 6 | 4036 | 12.7% |
| 2 | 720 | 2.3% |
| 5 | 11 | < 0.1% |
| 4 | 8 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 23919 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 55824 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 23919 | |
| 0 | 16226 | |
| 3 | 5522 | 9.9% |
| 1 | 5379 | 9.6% |
| 6 | 4036 | 7.2% |
| 2 | 720 | 1.3% |
| 5 | 11 | < 0.1% |
| 4 | 8 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 55824 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 23919 | |
| 0 | 16226 | |
| 3 | 5522 | 9.9% |
| 1 | 5379 | 9.6% |
| 6 | 4036 | 7.2% |
| 2 | 720 | 1.3% |
| 5 | 11 | < 0.1% |
| 4 | 8 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
versions_hmi_firmware
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2026 |
| Missing (%) | 20.3% |
| Memory size | 78.2 KiB |
| 65.1.39.34 | |
|---|---|
| 1.7.18.0 | |
| 1.7.28.0 | |
| 1.2.18.0 | |
| 1.2.28.0 | |
| Other values (4) | 16 |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 8.5812116 |
| Min length | 8 |
Characters and Unicode
| Total characters | 68418 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1.7.18.0 |
|---|---|
| 2nd row | 1.7.18.0 |
| 3rd row | 1.7.28.0 |
| 4th row | 65.1.39.34 |
| 5th row | 65.1.39.34 |
Common Values
| Value | Count | Frequency (%) |
| 65.1.39.34 | 2305 | |
| 1.7.18.0 | 1890 | |
| 1.7.28.0 | 1604 | |
| 1.2.18.0 | 1419 | |
| 1.2.28.0 | 739 | 7.4% |
| 65.1.20.34 | 9 | 0.1% |
| 1.7.20.0 | 4 | < 0.1% |
| 65.1.21.34 | 2 | < 0.1% |
| 65.1.27.34 | 1 | < 0.1% |
| (Missing) | 2026 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 65.1.39.34 | 2305 | |
| 1.7.18.0 | 1890 | |
| 1.7.28.0 | 1604 | |
| 1.2.18.0 | 1419 | |
| 1.2.28.0 | 739 | 9.3% |
| 65.1.20.34 | 9 | 0.1% |
| 1.7.20.0 | 4 | 0.1% |
| 65.1.21.34 | 2 | < 0.1% |
| 65.1.27.34 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 23919 | |
| 1 | 11284 | |
| 0 | 5669 | 8.3% |
| 8 | 5652 | 8.3% |
| 3 | 4622 | 6.8% |
| 2 | 4517 | 6.6% |
| 7 | 3499 | 5.1% |
| 6 | 2317 | 3.4% |
| 5 | 2317 | 3.4% |
| 4 | 2317 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 44499 | |
| Other Punctuation | 23919 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 11284 | |
| 0 | 5669 | |
| 8 | 5652 | |
| 3 | 4622 | |
| 2 | 4517 | |
| 7 | 3499 | 7.9% |
| 6 | 2317 | 5.2% |
| 5 | 2317 | 5.2% |
| 4 | 2317 | 5.2% |
| 9 | 2305 | 5.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 23919 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 68418 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 23919 | |
| 1 | 11284 | |
| 0 | 5669 | 8.3% |
| 8 | 5652 | 8.3% |
| 3 | 4622 | 6.8% |
| 2 | 4517 | 6.6% |
| 7 | 3499 | 5.1% |
| 6 | 2317 | 3.4% |
| 5 | 2317 | 3.4% |
| 4 | 2317 | 3.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 68418 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 23919 | |
| 1 | 11284 | |
| 0 | 5669 | 8.3% |
| 8 | 5652 | 8.3% |
| 3 | 4622 | 6.8% |
| 2 | 4517 | 6.6% |
| 7 | 3499 | 5.1% |
| 6 | 2317 | 3.4% |
| 5 | 2317 | 3.4% |
| 4 | 2317 | 3.4% |
versions_hmi_hardware
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2026 |
| Missing (%) | 20.3% |
| Memory size | 78.2 KiB |
| 1.0 | |
|---|---|
| 2.0 | |
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 23919 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 2.0 |
| 5th row | 2.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 3498 | |
| 2.0 | 2317 | |
| 0.0 | 2158 | |
| (Missing) | 2026 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 3498 | |
| 2.0 | 2317 | |
| 0.0 | 2158 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10131 | |
| . | 7973 | |
| 1 | 3498 | 14.6% |
| 2 | 2317 | 9.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 15946 | |
| Other Punctuation | 7973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 10131 | |
| 1 | 3498 | 21.9% |
| 2 | 2317 | 14.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 7973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 23919 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 10131 | |
| . | 7973 | |
| 1 | 3498 | 14.6% |
| 2 | 2317 | 9.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23919 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 10131 | |
| . | 7973 | |
| 1 | 3498 | 14.6% |
| 2 | 2317 | 9.7% |
| total_mileage | assist_level | battery_error_state | battery_state_battery_soc | battery_state_battery_soh | battery_state_cell_temp_1 | battery_state_cell_temp_2 | battery_state_chg_temp | battery_state_dsg_temp | battery_state_full_capacity | battery_state_pack_voltage | battery_state_pre_start_temp | battery_state_real_time_current | battery_state_remaining_capacity | remaining_mileage | versions_mc_firmware | dance_area | os_name | versions_battery_firmware | versions_hmi_firmware | versions_hmi_hardware | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| total_mileage | 1.000 | 0.020 | -0.081 | -0.031 | -0.350 | -0.137 | -0.139 | -0.148 | -0.149 | -0.273 | -0.033 | -0.150 | 0.066 | -0.154 | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.047 |
| assist_level | 0.020 | 1.000 | -0.081 | 0.002 | -0.042 | 0.044 | 0.043 | 0.059 | 0.058 | -0.004 | -0.067 | 0.057 | -0.111 | 0.040 | -0.383 | 0.000 | 0.000 | 0.014 | 0.000 | 0.086 | 0.049 |
| battery_error_state | -0.081 | -0.081 | 1.000 | 0.026 | 0.021 | -0.025 | -0.028 | -0.024 | -0.023 | -0.026 | 0.045 | -0.022 | 0.087 | -0.015 | -0.078 | 0.633 | 0.000 | 0.000 | 0.194 | 0.015 | 0.028 |
| battery_state_battery_soc | -0.031 | 0.002 | 0.026 | 1.000 | 0.025 | -0.023 | -0.023 | -0.021 | -0.021 | 0.006 | 0.678 | -0.020 | 0.128 | 0.326 | 0.823 | 0.081 | 0.013 | 0.066 | 0.050 | 0.015 | 0.026 |
| battery_state_battery_soh | -0.350 | -0.042 | 0.021 | 0.025 | 1.000 | 0.004 | 0.008 | 0.010 | 0.011 | 0.352 | 0.011 | 0.012 | -0.007 | 0.074 | 0.012 | 0.207 | 0.050 | 0.028 | 0.133 | 0.023 | 0.021 |
| battery_state_cell_temp_1 | -0.137 | 0.044 | -0.025 | -0.023 | 0.004 | 1.000 | 0.997 | 0.983 | 0.983 | 0.776 | -0.035 | 0.982 | -0.211 | 0.784 | -0.033 | 0.000 | 0.059 | 1.000 | 0.393 | 0.456 | 0.475 |
| battery_state_cell_temp_2 | -0.139 | 0.043 | -0.028 | -0.023 | 0.008 | 0.997 | 1.000 | 0.982 | 0.982 | 0.777 | -0.037 | 0.982 | -0.212 | 0.783 | -0.034 | 0.000 | 0.058 | 1.000 | 0.391 | 0.453 | 0.473 |
| battery_state_chg_temp | -0.148 | 0.059 | -0.024 | -0.021 | 0.010 | 0.983 | 0.982 | 1.000 | 1.000 | 0.778 | -0.045 | 1.000 | -0.224 | 0.783 | -0.039 | 0.000 | 0.079 | 1.000 | 0.397 | 0.466 | 0.402 |
| battery_state_dsg_temp | -0.149 | 0.058 | -0.023 | -0.021 | 0.011 | 0.983 | 0.982 | 1.000 | 1.000 | 0.778 | -0.046 | 1.000 | -0.224 | 0.783 | -0.039 | 0.000 | 0.079 | 1.000 | 0.397 | 0.466 | 0.402 |
| battery_state_full_capacity | -0.273 | -0.004 | -0.026 | 0.006 | 0.352 | 0.776 | 0.777 | 0.778 | 0.778 | 1.000 | -0.029 | 0.778 | -0.177 | 0.816 | -0.001 | 0.039 | 0.071 | 1.000 | 0.633 | 0.703 | 0.454 |
| battery_state_pack_voltage | -0.033 | -0.067 | 0.045 | 0.678 | 0.011 | -0.035 | -0.037 | -0.045 | -0.046 | -0.029 | 1.000 | -0.047 | 0.227 | 0.280 | 0.578 | 0.400 | 0.027 | 0.985 | 0.196 | 0.052 | 0.071 |
| battery_state_pre_start_temp | -0.150 | 0.057 | -0.022 | -0.020 | 0.012 | 0.982 | 0.982 | 1.000 | 1.000 | 0.778 | -0.047 | 1.000 | -0.223 | 0.783 | -0.040 | 0.000 | 0.079 | 1.000 | 0.397 | 0.466 | 0.402 |
| battery_state_real_time_current | 0.066 | -0.111 | 0.087 | 0.128 | -0.007 | -0.211 | -0.212 | -0.224 | -0.224 | -0.177 | 0.227 | -0.223 | 1.000 | -0.160 | 0.133 | 0.000 | 0.030 | 0.016 | 0.000 | 0.038 | 0.086 |
| battery_state_remaining_capacity | -0.154 | 0.040 | -0.015 | 0.326 | 0.074 | 0.784 | 0.783 | 0.783 | 0.783 | 0.816 | 0.280 | 0.783 | -0.160 | 1.000 | 0.248 | 0.000 | 0.060 | 1.000 | 0.305 | 0.404 | 0.446 |
| remaining_mileage | 0.003 | -0.383 | -0.078 | 0.823 | 0.012 | -0.033 | -0.034 | -0.039 | -0.039 | -0.001 | 0.578 | -0.040 | 0.133 | 0.248 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.032 |
| versions_mc_firmware | 0.000 | 0.000 | 0.633 | 0.081 | 0.207 | 0.000 | 0.000 | 0.000 | 0.000 | 0.039 | 0.400 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.039 | 0.038 | 0.190 | 0.035 | 0.052 |
| dance_area | 0.000 | 0.000 | 0.000 | 0.013 | 0.050 | 0.059 | 0.058 | 0.079 | 0.079 | 0.071 | 0.027 | 0.079 | 0.030 | 0.060 | 0.000 | 0.039 | 1.000 | 0.034 | 0.177 | 0.205 | 0.298 |
| os_name | 0.000 | 0.014 | 0.000 | 0.066 | 0.028 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.985 | 1.000 | 0.016 | 1.000 | 0.000 | 0.038 | 0.034 | 1.000 | 0.095 | 0.105 | 0.079 |
| versions_battery_firmware | 0.000 | 0.000 | 0.194 | 0.050 | 0.133 | 0.393 | 0.391 | 0.397 | 0.397 | 0.633 | 0.196 | 0.397 | 0.000 | 0.305 | 0.000 | 0.190 | 0.177 | 0.095 | 1.000 | 0.586 | 0.405 |
| versions_hmi_firmware | 0.000 | 0.086 | 0.015 | 0.015 | 0.023 | 0.456 | 0.453 | 0.466 | 0.466 | 0.703 | 0.052 | 0.466 | 0.038 | 0.404 | 0.000 | 0.035 | 0.205 | 0.105 | 0.586 | 1.000 | 1.000 |
| versions_hmi_hardware | 0.047 | 0.049 | 0.028 | 0.026 | 0.021 | 0.475 | 0.473 | 0.402 | 0.402 | 0.454 | 0.071 | 0.402 | 0.086 | 0.446 | 0.032 | 0.052 | 0.298 | 0.079 | 0.405 | 1.000 | 1.000 |
| vehicle_id | user_id | total_mileage | versions_mc_firmware | occurred_at_time | app_version | assist_level | battery_cells | battery_error_state | battery_serial_number | battery_state_battery_soc | battery_state_battery_soh | battery_state_cell_temp_1 | battery_state_cell_temp_2 | battery_state_chg_temp | battery_state_dsg_temp | battery_state_full_capacity | battery_state_pack_voltage | battery_state_pre_start_temp | battery_state_real_time_current | battery_state_remaining_capacity | dance_area | event | hmi_serial_number | os_name | remaining_mileage | versions_battery_firmware | versions_hmi_firmware | versions_hmi_hardware | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | bc3412f7-37a8-4676-8043-53f4a1bb316a | ca73adbe-5930-45ba-af74-de5865d8b093 | 7281.0 | DA210815.10 | 2023-04-05 08:54:50 | 2023.03.24-3923-prod-release | 0.0 | [null,null,null,null,null,null,null,null,null,null] | 0.0 | HT1002MA121521183 | 65.0 | 98.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 38925.0 | 0.0 | -60.0 | 0.0 | PARIS | Vehicle Connected | 60968A | Android | 1300.0 | 0.3.3.0 | 1.7.18.0 | 1.0 |
| 1 | 95e7ee01-3987-481a-9000-3b331c52192f | 6560e385-b90d-42be-b977-5cdb3a5d5a60 | NaN | NaN | 2022-09-05 18:13:47 | 2022.8.26 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | PARIS | Vehicle Connected | NaN | iOS | NaN | NaN | NaN | NaN |
| 2 | c63d60f2-5e2a-483c-bb11-935c45ebf2f0 | 118047dc-bf44-4dc0-9862-0cb3ac5db65d | 1185.0 | DA210815.10 | 2023-09-10 12:22:06 | 2023.9.4 | 1.0 | NaN | 0.0 | NaN | 89.0 | 94.0 | NaN | NaN | NaN | NaN | NaN | -24763.0 | NaN | -30.0 | NaN | BERLIN | Vehicle Connected | 2C139F | iOS | 712.0 | 0.3.3.0 | 1.7.18.0 | 1.0 |
| 3 | 79df825d-8115-4a84-9aa8-87ae307ae561 | f0c0ac6d-32a1-45ed-9de1-466455fa637a | 378.0 | DA210815.10 | 2022-09-14 07:50:05 | 2022.08.30-3095-prod-release | 2.0 | [3997,3997,4001,3994,4000,4013,4014,4015,4009,4012] | 0.0 | HT1002MA121251821 | 79.0 | 99.0 | 17.0 | 17.0 | 17.0 | 17.0 | 9468.0 | 40052.0 | 17.0 | -107.0 | 7479.0 | BERLIN | Vehicle Connected | 73D58B | Android | 474.0 | 1.0.6.0 | 1.7.28.0 | 1.0 |
| 4 | 0d30c889-a102-4bdc-b8a3-c1e0d6c536d5 | 2b9f8b3f-b3f3-409b-ade0-dd9ae8b54ba7 | NaN | NaN | 2022-09-12 14:12:19 | 2022.8.29 | NaN | NaN | 0.0 | 4854313030324d41313231353231373236000000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HAMBURG | Vehicle Connected | NaN | iOS | NaN | NaN | NaN | NaN |
| 5 | 5c1e2a7b-afc5-482d-96d0-12c2f938e712 | a3afa394-cf40-450a-b323-a1d23d685f38 | NaN | NaN | 2022-09-11 17:14:15 | 2022.8.29 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | PARIS | Vehicle Connected | NaN | iOS | NaN | NaN | NaN | NaN |
| 6 | 2d31a77f-26ad-4f92-bd9f-a44d2ad79c89 | 8c169cd9-274d-4025-9dd9-bc762f8b385d | 1135.0 | DA210815.10 | 2023-07-26 07:00:22 | 2023.7.20 | 2.0 | NaN | 0.0 | HT1002MA122120371HT1002MA122120371HT1002MA122120371HT1002MA122120371HT1002MA122120371 | 95.0 | 99.0 | NaN | NaN | NaN | NaN | NaN | -24776.0 | NaN | -2603.0 | NaN | PARIS | Vehicle Connected | 22491134 | iOS | 570.0 | 1.0.6.0 | 65.1.39.34 | 2.0 |
| 7 | a53f881c-af7b-4f32-bf8d-13eef013d4b1 | 4fe83c19-4de1-4dd0-97dc-4e5ae5850b2b | NaN | NaN | 2022-11-05 07:16:31 | 2022.10.11 | NaN | NaN | 0.0 | HT1002MA121340143 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | MUNICH | Vehicle Connected | 89F0D3 | iOS | NaN | NaN | NaN | NaN |
| 8 | d2ce3fbd-f352-42ce-bf6d-19abcac8db32 | dd798684-8ff6-422c-9c42-a05b70dc6140 | 323.0 | DA210815.10 | 2023-08-08 12:45:07 | 2023.08.04-4184-prod-release | 1.0 | [4081,4081,4082,4083,4081,4085,4083,4083,4085,4083] | 0.0 | HT1002MA12244004 | 92.0 | 99.0 | 25.0 | 25.0 | 25.0 | 25.0 | 9491.0 | 40829.0 | 25.0 | -96.0 | 8700.0 | PARIS | Vehicle Connected | 23020758 | Android | 736.0 | 1.0.6.0 | 65.1.39.34 | 2.0 |
| 9 | c88d33c5-c6a6-421a-9deb-9722c36b1617 | 6dcaf0ea-3b9d-4666-bd04-9661ce79cc44 | 11254.0 | DA210815.10 | 2023-07-17 13:58:29 | 2023.07.06-4135-prod-release | 2.0 | [3913,3911,3911,3911,3911,3923,3921,3914,3923,3922] | 0.0 | HT1002MA12140156 | 68.0 | 91.0 | 33.0 | 32.0 | 34.0 | 34.0 | 8693.0 | 39164.0 | 34.0 | -96.0 | 5901.0 | BERLIN | Vehicle Connected | 22510490 | Android | 408.0 | 0.3.3.0 | 65.1.39.34 | 2.0 |
| vehicle_id | user_id | total_mileage | versions_mc_firmware | occurred_at_time | app_version | assist_level | battery_cells | battery_error_state | battery_serial_number | battery_state_battery_soc | battery_state_battery_soh | battery_state_cell_temp_1 | battery_state_cell_temp_2 | battery_state_chg_temp | battery_state_dsg_temp | battery_state_full_capacity | battery_state_pack_voltage | battery_state_pre_start_temp | battery_state_real_time_current | battery_state_remaining_capacity | dance_area | event | hmi_serial_number | os_name | remaining_mileage | versions_battery_firmware | versions_hmi_firmware | versions_hmi_hardware | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9989 | 61a771fd-f11b-4144-8842-73ebd69471b8 | 04445577-ab03-46db-bd07-744d3c58f71c | 105.0 | DA210815.10 | 2023-08-31 16:16:55 | 2023.8.16 | 1.0 | NaN | 0.0 | HT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\nHT1002MA323310199\r\n | 82.0 | 100.0 | NaN | NaN | NaN | NaN | NaN | -25304.0 | NaN | -74.0 | NaN | PARIS | Vehicle Connected | 23070809 | iOS | 656.0 | 1.0.6.0 | 65.1.39.34 | 2.0 |
| 9990 | 74015cd1-8b8d-40f2-92bd-9f7f17fd8831 | 2bec0841-17cf-4404-ae1c-852e5e375553 | 2806.0 | DA210815.10 | 2022-10-20 12:00:33 | 2022.10.12 | 2.0 | NaN | 0.0 | HT1002MA121402039 | 20.0 | 98.0 | NaN | NaN | NaN | NaN | NaN | -30679.0 | NaN | -65.0 | NaN | PARIS | Vehicle Connected | 87B451 | iOS | 120.0 | 0.3.2.0 | 1.7.18.0 | 1.0 |
| 9991 | 6eca4ad4-0aca-443a-954d-9983a9d1a7b0 | 725e1583-c2c3-47e3-ab91-3d2a6136e4b2 | 2431.0 | DA210815.10 | 2023-05-01 18:32:53 | 2023.4.21 | 2.0 | NaN | 0.0 | HT1002MA122260713 | 34.0 | 95.0 | NaN | NaN | NaN | NaN | NaN | -29721.0 | NaN | -6715.0 | NaN | PARIS | Vehicle Connected | F179D7 | iOS | 204.0 | 1.0.3.0 | 1.7.18.0 | 1.0 |
| 9992 | ca4c5d0d-0d08-4189-b8ee-e8cd4d337422 | 7d7c1e29-1a35-447c-b672-5899a55bc6f1 | 12411.0 | DA210815.10 | 2022-08-30 18:59:02 | 2022.8.26 | 2.0 | NaN | 0.0 | 4854313030324d41313232303831383633000000 | 73.0 | 97.0 | NaN | NaN | NaN | NaN | NaN | -26146.0 | NaN | -57.0 | NaN | PARIS | Vehicle Connected | 324333373044 | iOS | 438.0 | 0.3.3.0 | 1.7.18.0 | 1.0 |
| 9993 | 6f700383-48f2-4aa7-9ede-d0437f90c09f | f4b7ecf1-5feb-4197-8bca-883513fc63af | 8949.0 | DA210815.10 | 2023-05-16 13:49:36 | 2023.3.17 | 2.0 | NaN | 0.0 | HT1002MA121520495 | 85.0 | 98.0 | NaN | NaN | NaN | NaN | NaN | -24992.0 | NaN | -65.0 | NaN | PARIS | Vehicle Connected | 5F1807 | iOS | 510.0 | 0.3.3.0 | 1.7.28.0 | 1.0 |
| 9994 | bd1e99fc-086e-4260-9cc4-f291d63002d9 | b59b0854-5153-4e62-96df-db84293162cf | 2713.0 | DA210815.10 | 2023-07-07 07:22:27 | 2023.6.12 | 2.0 | NaN | 0.0 | NaN | 46.0 | 98.0 | NaN | NaN | NaN | NaN | NaN | -30683.0 | NaN | -11007.0 | NaN | PARIS | Vehicle Connected | 22510450 | iOS | 276.0 | 1.0.6.0 | 65.1.39.34 | 2.0 |
| 9995 | 89f28faa-77ef-4022-a767-86c8eeb42d2f | f958f248-e4cc-40c3-8e6b-d0e4b8429c46 | 21101.0 | DA210815.10 | 2023-09-11 14:40:10 | 2023.9.4 | 2.0 | NaN | 0.0 | NaN | 73.0 | 96.0 | NaN | NaN | NaN | NaN | NaN | -26271.0 | NaN | -63.0 | NaN | HAMBURG | Vehicle Connected | 2CBE66 | iOS | 438.0 | 1.0.6.0 | 1.2.28.0 | 0.0 |
| 9996 | d2e8184f-15d5-4765-84ab-feceeecf6c9e | ce60d719-e603-4c6b-b5d1-36f49cafd0a7 | NaN | NaN | 2022-12-07 07:24:14 | 2022.11.28 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HAMBURG | Vehicle Connected | NaN | iOS | NaN | NaN | NaN | NaN |
| 9997 | da69c76a-3c9a-4226-846b-996257559b72 | 2d8b3fd6-3e40-4674-8c47-d8450a9c3671 | 5505.0 | DA210815.10 | 2023-03-09 19:26:15 | 2023.3.3 | 2.0 | NaN | 0.0 | HT1002MA121400838 | 82.0 | 98.0 | NaN | NaN | NaN | NaN | NaN | -25513.0 | NaN | -60.0 | NaN | PARIS | Vehicle Connected | 64AC8B | iOS | 492.0 | 0.3.2.0 | 1.7.18.0 | 1.0 |
| 9998 | ce3f2756-3d57-4e03-abfd-d4df018f39a0 | f1ed0715-e3ff-4e47-8c94-51bd61063e99 | NaN | NaN | 2023-01-20 12:45:46 | 2023.1.11 | NaN | NaN | 0.0 | HT1002MA121220008 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HAMBURG | Vehicle Connected | 63316E | iOS | NaN | NaN | NaN | NaN |
Most frequently occurring
| vehicle_id | user_id | total_mileage | versions_mc_firmware | occurred_at_time | app_version | assist_level | battery_cells | battery_error_state | battery_serial_number | battery_state_battery_soc | battery_state_battery_soh | battery_state_cell_temp_1 | battery_state_cell_temp_2 | battery_state_chg_temp | battery_state_dsg_temp | battery_state_full_capacity | battery_state_pack_voltage | battery_state_pre_start_temp | battery_state_real_time_current | battery_state_remaining_capacity | dance_area | event | hmi_serial_number | os_name | remaining_mileage | versions_battery_firmware | versions_hmi_firmware | versions_hmi_hardware | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 019e70dd-64f0-4527-9aff-e09ef5743dd0 | 6afca364-1442-4920-8e10-68930b1f112a | 9483.0 | DA210815.10 | 2023-08-27 15:34:20 | 2023.8.16 | 2.0 | NaN | 0.0 | HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817HT1002MA122440817 | 37.0 | 98.0 | NaN | NaN | NaN | NaN | NaN | -30699.0 | NaN | -5405.0 | NaN | PARIS | Vehicle Connected | 22511089 | iOS | 222.0 | 1.0.6.0 | 65.1.39.34 | 2.0 | 2 |
| 1 | c1942627-dc25-4d5f-8c5e-8179a2de72d7 | 1ed581fe-31e1-4869-98e4-4cc18c9aeffa | 2139.0 | DA210815.10 | 2023-06-20 17:50:17 | 2023.6.12 | 2.0 | NaN | 0.0 | HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT1002MA122330192HT | 40.0 | 99.0 | NaN | NaN | NaN | NaN | NaN | -29384.0 | NaN | -98.0 | NaN | PARIS | Vehicle Connected | B808D4 | iOS | 240.0 | 1.0.6.0 | 1.7.28.0 | 1.0 | 2 |
| 2 | fd878446-1c44-4a9f-b88f-10ce83cade59 | d453aad8-6c95-425a-8a63-f9fe012554f8 | 16985.0 | DA210815.10 | 2023-06-20 15:37:03 | 2023.6.12 | 1.0 | NaN | 0.0 | NaN | 31.0 | 98.0 | NaN | NaN | NaN | NaN | NaN | -30029.0 | NaN | -65.0 | NaN | BERLIN | Vehicle Connected | 48C70B | iOS | 248.0 | 1.0.3.0 | 1.7.18.0 | 1.0 | 2 |